FreeTDS Development Group

["Sebastian Willing" <swi AT e-cross.de>]

Dear FreeTDS list members,

I just started using Sybase SQL a month ago (never used mySQL before).
Currently, I'm testing with Anywhere 10 Dev, Perl DBI and FreeTDS.

My test server (called "test") is running a database called "test" and
everything is working fine. Now I added another database to the same server.

When running

perl -MDBD::Sybase -le '$DB_Conn =
DBI->connect("dbi:Sybase:server=test;host=1.2.3.4;port=56789;database=test",
"dbusername","dbpassword") or die $!; print $DB_Conn'

(I replaced the real values for IP, Port, User and Pass for posting here.)

After starting up the server with only one database, everything works fine.
But when I start the second database on the same server (via Interactive SQL
or via "START DATABASE '/path/to/db/test2.db' AUTOSTOP OFF"), the following
error occurs:

DBI
connect('server=test;host=1.2.3.4;port=56789;database=test','dbusername',...
) failed: Server message number=911 severity=16 state=0 line=0 text=SQL
Anywhere-Fehler -83: Angegebene Datenbank nicht gefundenOpenClient message:
LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (46)
Server test, database 
Message String: Login incorrect.
 at -e line 1
Died at -e line 1.

Notice that the error message contains "Server test" but "database
<nothing>". The server's log also doesn't show any database name.

Anywhere 10 has no server auth information, so the database name is needed
for logging in.

Exactly the same command line works find on a machine using Sybase
OpenClient.

Sybase Central is always able to log into all running databases.

Is this a user error or a FreeTDS bug?

Best Regards,
Sebastian