Recent

Author Topic: Connecting from Linux to Win2000 IB-server  (Read 11448 times)

matthijs

  • Hero Member
  • *****
  • Posts: 537
Connecting from Linux to Win2000 IB-server
« on: January 27, 2005, 06:18:19 pm »
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?
What's in a sig? Would my posting look less if it didnot have a sig? (Free after William S.) :)

:( Why cannot I upload my own Avatar? :(

Anonymous

  • Guest
Connecting from Linux to Win2000 IB-server
« Reply #1 on: January 27, 2005, 06:26:21 pm »
Try using the address directly 192.168.*.* or whatever the address is

Lightning

  • Sr. Member
  • ****
  • Posts: 422
Connecting from Linux to Win2000 IB-server
« Reply #2 on: January 27, 2005, 06:44:31 pm »
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.
The future must be... Fast and OpenSource so...
Think Open and Lightning Fast!

matthijs

  • Hero Member
  • *****
  • Posts: 537
Connecting from Linux to Win2000 IB-server
« Reply #3 on: January 27, 2005, 08:21:24 pm »
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.
What's in a sig? Would my posting look less if it didnot have a sig? (Free after William S.) :)

:( Why cannot I upload my own Avatar? :(

Lightning

  • Sr. Member
  • ****
  • Posts: 422
Connecting from Linux to Win2000 IB-server
« Reply #4 on: January 28, 2005, 08:10:01 pm »
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.
The future must be... Fast and OpenSource so...
Think Open and Lightning Fast!

matthijs

  • Hero Member
  • *****
  • Posts: 537
Connecting from Linux to Win2000 IB-server
« Reply #5 on: January 28, 2005, 08:37:29 pm »
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.
What's in a sig? Would my posting look less if it didnot have a sig? (Free after William S.) :)

:( Why cannot I upload my own Avatar? :(

Galileo

  • New Member
  • *
  • Posts: 21
Connecting from Linux to Win2000 IB-server
« Reply #6 on: January 28, 2005, 09:32:42 pm »
Maybe i saying something stupid, but do you try to put you server IP in the /etc/host.allow file?

matthijs

  • Hero Member
  • *****
  • Posts: 537
Connecting from Linux to Win2000 IB-server
« Reply #7 on: January 29, 2005, 12:34:51 pm »
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 :) )
What's in a sig? Would my posting look less if it didnot have a sig? (Free after William S.) :)

:( Why cannot I upload my own Avatar? :(

Lightning

  • Sr. Member
  • ****
  • Posts: 422
Connecting from Linux to Win2000 IB-server
« Reply #8 on: January 30, 2005, 09:18:39 am »
It is a really annoying problem. if i have some time i willl try it myself.
The future must be... Fast and OpenSource so...
Think Open and Lightning Fast!

Galileo

  • New Member
  • *
  • Posts: 21
Connecting from Linux to Win2000 IB-server
« Reply #9 on: January 31, 2005, 05:16:34 pm »
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.