interbase 6 connnection troubles

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bsides
Forum Newbie
Posts: 2
Joined: Thu Mar 20, 2003 12:17 am

interbase 6 connnection troubles

Post by bsides »

Hi,

I am trying to get the webserver (linux) to connect to an interbase 6 database on the client pc(win2k). This works fine in our development environment (all win2k server/client pc's), but not from our production webserver which is linux.

Here's how I connect (or try to!):
$host = getClientIP().':C:/MyIbaseDB.GDB';
$dbh = ibase_connect($host, 'username', 'password');

getClientIP() returns the client IP address.

This gives me the following error:
Warning: InterBase: Unable to complete network request to host "123.45.67.890". Failed to locate host machine. Undefined service gds_db/tcp.

I have checked my SERVICES files, the server and client in the development environment both have the "gds_db 3050/tcp" line. The company hosting our webserver has verified this setting also exists at their end.

Also, I tested the availability of the interbase database using isql from another pc and can connect using the IP address, username/pwd used above. However, isql on the linux server cannot connect and reports the following:
Statement failed, SQLCODE = -902

Unable to complete network request to host "123.45.67.890".
-Failed to locate host machine.
-Undefined service gds_db/tcp.

Has anyone any information that may help me resolve this problem. All help is much appreciated.


Rgds,

Marcus
Post Reply