hendrang Posted September 2, 2012 Posted September 2, 2012 Hi All, I am using AnyDac component and firebird database. Suppose that the Web Server IP Address is 2.22.22.222 and the web application want to connect database reside in client computer (IP Address 3.33.33.333) with code like this : idx:= ADConnection1.Params.IndexOfName('Database'); ADConnection1.Params[idx]:= 'Database= 3.33.33.333:C:\Employee.fdb'; ADConnection1.Connected:= True; raise Ajax Error : Server unavailable My plan is not to host the web application and the database in the same computer. as I read article Database Security Best Practices : Separate the Database and Web Servers so that mean the web application computer and database server computer will have different IP Address. Thanks in advance. Quote
zilav Posted September 2, 2012 Posted September 2, 2012 Can you ping db server from web server? Quote
hendrang Posted September 3, 2012 Author Posted September 3, 2012 Can you ping db server from web server? Hi, thanks and sorry for my late reply. Yes I can ping db Server(client computer) from web server and vice versa. And the process connecting database is done in client computer, this mean the user in client computer try to connect his local database. I also try to remote connect the client database (I can ping the client computer) from my computer with Desktop application (create with VCL Delphi not uniGUI) but failed either. the error message is : Unable to complete network request to host 'xx.xx.xxxx' <- client ip address failed to establish a connection. I used to be able remote connect the client database use the desktop application but now fail to connect. So I think this is not because of UniGUI application, but network connection problem. I use Logmein Hamachi to connect client computer. Quote
hendrang Posted September 3, 2012 Author Posted September 3, 2012 Disable firewall solve the problem. I have to disable Windows Firewall and firewall of anti virus Eset Smart Security on the client computer. My uniGui Web Application can connect remote database. Quote
adragan Posted September 3, 2012 Posted September 3, 2012 Did you install on the 2.22.22.222 computer the Firebird client. Since you're using ADO did you install, configure and test the ODBC driver ? Quote
hendrang Posted September 3, 2012 Author Posted September 3, 2012 Did you install on the 2.22.22.222 computer the Firebird client. Since you're using ADO did you install, configure and test the ODBC driver ? Hi, Firebird server run on 2.22.22.222 (Web server) and 3.33.33.333 (client computer) Maybe Firebird server need not run on 2.22.22.222 (Web server) cause Database now on 3.33.33.333, I will test it later. I use Anydac not ADO, not configure and test the ODBC driver. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.