Connecting from Linux to Win2000 IB-server
lazarus / 16-Databases

----------------------------------------------------------------------
matthijs · 2005-01-27 17:18

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:
Quote
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 · 2005-01-27 17:26

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

----------------------------------------------------------------------
Lightning · 2005-01-27 17:44

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 · 2005-01-27 19:21

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:
Quote
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 · 2005-01-28 19:10

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 · 2005-01-28 19:37

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 · 2005-01-28 20:32

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

----------------------------------------------------------------------
matthijs · 2005-01-29 11:34

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 · 2005-01-30 08:18

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

----------------------------------------------------------------------
Galileo · 2005-01-31 16:16

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.