How to connect database reside other place than in web server

[hendrang]

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.

[zilav]

Can you ping db server from web server?

[hendrang]

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.

[hendrang]

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.

[adragan]

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 ?

[hendrang]

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.