Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: KParamasivam AT claritas.com
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] using freeTDS and DBD::Sybase to connect to Sybase Server
  • Date: Wed, 19 Apr 2006 15:27:30 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page