Connecting from Linux to Win2000 IB-server

[matthijs]

Hi,

I have Lazarus running on a Win2K and on a Linux box. I installed on both machines the IB-components. I can connect to local databases.
I can connect from my Win2K box to a database on the Linux box. However I am unable to connect from my Linux box to a database on the Win2K machine,
I receive the following error messages:

TIBDatabase.Open:
- Unable to complete network request to host "linux".
- Failed to locate host machine.
- Undefined service /athlon/tcp.

My Win2K is called: Athlon, the linux machine is called Linux.

Has anyone got a clue?

[Anonymous]

Try using the address directly 192.168.*.* or whatever the address is

[Lightning]

Did you try from the console too ?
You still haven't swiched to FireBird ?
Well did you use the machine name to connect or the IP ?
From what i know Linux doesn't recognise Windows host names, except if you're using some app to do this.
You must edit /etc/hosts file and add aliases/names and their IP.

[matthijs]

I did try with the IP-adress. Didnot help either.
I edited /etc/hosts and added the Win2K box. Then tried again:

Code: [Select]


database := athlon:/athlon_g/Program Files/Common Files/Borland Shared/Data/EMPLOYEE.GDB

gives the following error:

TIBDatabase.open:
- I/O error for file "/athlon_g/Program Files/Common Files/Borland Shared/Data/EMPLOYEE.GDB"
- Error while trying to open ile.
- The system cannot find the path specified.

So now it looks that after adding the other computer to the hosts file I'm a step closer. All I have to do know is figure out how to enter the path to the database file.

[Lightning]

I think your path should be the windows path since that server is running on windows.
instead of "/athlon_g/Program Files/Common Files/Borland Shared/Data/EMPLOYEE.GDB" you should have
"G:\Program Files\Common Files\Borland Shared\Data\EMPLOYEE.GDB"
Your path is a linux path, this would work if you would like to use that file on localhost, however i think you need a trick/setting to use a network file as local with FB/IB.
OFF-TOPIC: change the .gdb extension to .idb or some other extension since .gdb is a reserved windows extension and will reduce the speed of your server, read more on ibphoenix website.

[matthijs]

I tried entering a windows path in all kind of formats. I just have not been able to find the right format, maybe I'll post it to the list as well.

[Galileo]

Maybe i saying something stupid, but do you try to put you server IP in the /etc/host.allow file?

[matthijs]

Adding the other server to /etc/hosts.allow would enable the server to connect to my machine. And I can read the database on the linux server from the w2k pc. I cannot read the database on the w2k frrom the linux pc. I can connect to the w2k pc, but get a message that the file cannot be found. So the question really is how can I tell where the database file is on the w2k pc.

(but just to be sure I added the IP to the hosts.allow )

[Lightning]

It is a really annoying problem. if i have some time i willl try it myself.

[Galileo]

Sorry: another stupid question
I presume that you can access the FB database in your W2k server localy, using the SAME (exactly) path that you try from Linux box.
Remmeber that the path is the LOCAL path where the FB is running.