Remote connection problem

Forum related to Firebird

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
kerino
Junior Boarder
Junior Boarder
Posts: 27
Joined: 26.06.2008, 10:04

Remote connection problem

Post by kerino »

Hi, I've been trying for a week now to access a Firebird DB over a LAN without any success. I'm running Delphi5 Pro and Zeos 6.6.5. Once PC is running XP and the other WIN2000.
I have established that the 2 PC's can ping each other, and that port 3050 is not blocked.
Both PC's are running Firebird 2.1 as a service.
In the TZconnection I enter the HostName as 192.168.1.105 (the other PC), and in the Port I enter 3050. I navigate using the browser to the database (in this case \\Mesh2XT\roes\ljm.fdb) and try to connect at design time, and get the error "Unable to complete network request to host" ...."connected party did not properly respond" etc.
I'm all out of ideas :(
Can anyone help me please?
Many thanks - Kerin
kerino
Junior Boarder
Junior Boarder
Posts: 27
Joined: 26.06.2008, 10:04

Post by kerino »

I have found the answer.
I have to use the local path name on the remote PC instead of the remote name i.e. C:\roes\ljm.fdb.
Thanks for looking
Kerin
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

Indeed :D

There's even a better solution (in my opinion). If you use the aliases file in your firebird installation your client doesn't have to know the physical location of the database on the server. So the db admin can move the file around without the clients needing new configurations.

See http://www.janus-software.com/fbmanual/ ... in&topic=4

Mark
Image
kerino
Junior Boarder
Junior Boarder
Posts: 27
Joined: 26.06.2008, 10:04

Post by kerino »

Thanks Mark - that is better.
Post Reply