Skip to Content.
Sympa Menu

freetds - [freetds] Database name not working?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Sebastian Willing" <swi AT e-cross.de>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Database name not working?
  • Date: Thu, 17 Jan 2008 10:45:03 +0100

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





  • [freetds] Database name not working?, Sebastian Willing, 01/17/2008

Archive powered by MHonArc 2.6.24.

Top of Page