Skip to Content.
Sympa Menu

freetds - [freetds] perl sybase driver problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Shane" <swilli40 AT hotmail.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] perl sybase driver problem
  • Date: Tue, 28 Oct 2003 12:11:04 -0000

Please mail this address, as I probably wont be able to read the mailing list.

I installed freetds to allow me to connect to a mssql 2000 database. The
installation went well and all tests passed when i ran 'make check'.

tsql can succesfully connect to the database and i can run queries.

the problem:
i want to use perl DBD::Sybase to connect and run queries, but I keep getting
errors. I have installed the latest DBD::Sybase, which didn't work because it
was asking for config files. I reverted to 0.91 version of this driver which
seems to get further, but still doesn't work. Does this driver use the
freetds libs? Does the freetds.conf get used at all when using the sybase
driver?

below is the error that I am getting now.

DBI 1.38-ithread dispatch trace level set to 2
-> DBI->connect(dbi:Sybase:server=RATIONAL_DB, clearquest_admin, ****,
HASH(0x4001cfa4))
-> DBI->install_driver(Sybase) for hpux perl=5.006001 pid=589 ruid=1000
euid=1000
install_driver: DBD::Sybase version 0.91 loaded from
/u/vobadm/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi//DBD/Sybase.pm
<- install_driver= DBI::dr=HASH(0x4012fbcc)
-> connect for DBD::Sybase::dr (DBI::dr=HASH(0x4012fbcc)~0x400392e4
'server=RATIONAL_DB' 'clearquest_admin' **** HASH(0x401d5bec)) thr#4001bcd8
OpenClient message: LAYER = (7) ORIGIN = (2) SEVERITY = (6) NUMBER = (6)
Message String: ct_con_alloc(): unable to get layer message string: unable to
get origin message string: error string not available
ct_con_alloc failed at
/u/vobadm/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi//DBD/Sybase.pm
line 73.
<- connect= undef at DBI.pm line 585
-> errstr in DBD::_::common for DBD::Sybase::dr
(DBI::dr=HASH(0x4012fbcc)~0x400392e4) thr#4001bcd8
<- errstr= undef at DBI.pm line 588
DBI connect('server=RATIONAL_DB','clearquest_admin',...) failed: (no
error string)
DBI connect('server=RATIONAL_DB','clearquest_admin',...) failed: (no error
string) at ./test.pl line 15
-> DESTROY for DBD::Sybase::db (DBI::db=HASH(0x401d5c1c)~INNER)
thr#4001bcd8
DESTROY for DBI::db=HASH(0x401d5c1c) ignored - handle not initialised
<- DESTROY= undef at DBI.pm line 645
-> $DBI::errstr (&) FETCH from lasth=HASH
>> DBD::Sybase::dr::errstr
<- $DBI::errstr= undef
Use of uninitialized value in concatenation (.) or string at ./test.pl line
17.
Unable for connect to server at ./test.pl line 17.
-- DBI::END
-> disconnect_all for DBD::Sybase::dr
(DBI::dr=HASH(0x4012fbcc)~0x400392e4) thr#4001bcd8
<- disconnect_all= 1 at DBI.pm line 653
! -> DESTROY for DBD::Sybase::dr (DBI::dr=HASH(0x400392e4)~INNER)
thr#4001bcd8
! <- DESTROY= (not implemented) during global destruction


ENV:
SYBASE=/opt/sybase
FREETDSCONF=/usr/etc


if i make SYBASE=/usr/local/lib i get Cannot access file
/usr/lib/config/objectid.dat



thanks





Archive powered by MHonArc 2.6.24.

Top of Page