Skip to Content.
Sympa Menu

freetds - [freetds] two Sybase servers

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Florian Kornhoffer" <f.kornhoffer AT laufwerk.de>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] two Sybase servers
  • Date: Tue, 23 Nov 2004 20:08:29 +0100

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






Archive powered by MHonArc 2.6.24.

Top of Page