[freetds] using freeTDS and DBD::Sybase to connect to Sybase Server

KParamasivam@claritas.com KParamasivam at claritas.com
Wed Apr 19 15:27:30 EDT 2006


Hello,
I use perl 5.85, DBD-Sybase-1.07, DBI 1.5, freetds 0.63.

my query string is login as: root

$dbh = DBI->connect("DBI:Sybase:server=test; database=test1", $user, 
$passwd, {PrintError => 0});

and settings in freetds.conf:
[test]
host = 10.x.x.x
port=2638
tds version=5.0

When I run the test program, I get the below error: But I'm able to login 
from a sybase client in windows machine using same database, username, 
password.

Unable for connect to server Server message number=911 severity=16 state=0 
line=0 text=ASA Error -83: Specified database not foundOpenClient message: 
LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (46)
Server test, database
Message String: Login incorrect.

Using tds version=8.0 gives me a different error:

Unable for connect to server OpenClient message: LAYER = (0) ORIGIN = (0) 
SEVERITY = (78) NUMBER = (36)
Server medicalcenter-iq, database
Message String: Read from SQL server failed.
OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (46)
Server test, database
Message String: Login incorrect.

I would be great if somebody could point if I'm overlooking some thing 
here.

Thanks,
Karthik


More information about the FreeTDS mailing list