[freetds] two Sybase servers

Florian Kornhoffer f.kornhoffer at laufwerk.de
Tue Nov 23 14:08:29 EST 2004


Hi,

we added a new Sybase Anywhere 8 DB to our server which is reachable on the
same IP but an other port. This works fine with ODBC.

With freetds on our webserver the connection to DB1 (the older one) still
works, the newer one does not!

Here are the freetds.conf values:

# Verbindung zu DB1
[DB1]
        host = Server-IP
        port = 2639
        tds version = 5.0

# Verbindung zu DB2
[DB2]
        host = Server-IP
        port = 2640
        tds version = 5.0


DB1 is a default configuration with listening on port 2638, DB2 has same
configuration except Parameter Port: -x tcpip(port=2640)
Db1 has only: -x tcpip

The router NATs correctly 2639 to 2638 and 2640 to 2640.


When connection to DB1 from a php-page with
	$link = sybase_connect( $host= 'DB2', $user= 'x', $pass= 'y');

I get an error:

Warning: sybase_connect(): Sybase: Server message: ASA Fehler -83:
Angegebene Datenbank nicht gefunden (severity 16, procedure N/A) in
/opt/root/home/kundende/connect.syb.php on line 3

Warning: sybase_connect(): Sybase: Client message: Login incorrect.
(severity 78) in /opt/root/home/lw-kundende/connect.syb.php on line 3

Warning: sybase_connect(): Sybase: Unable to connect in
/opt/root/home/lw-kundende/connect.syb.php on line 3


What can be the cause for that? Are there problems with having two DBs on
one Server? Or is that a port problem? Or ......???

Thanks
Florian





More information about the FreeTDS mailing list