Skip to Content.
Sympa Menu

freetds - Re: [freetds] perl sybase driver problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc: swilli40 AT hotmail.com
  • Subject: Re: [freetds] perl sybase driver problem
  • Date: Tue, 28 Oct 2003 09:05:30 -0800

On Tue, 2003-10-28 at 04:11, Shane wrote:
> 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.

I think that the problem is that DBD::Sybase is built with the Sybase
libraries, not with FreeTDS, or at least that it is picking up the
Sybase libraries at run time.

Try rebuilding DBD::Sybase (1.01 should work fine) by setting SYBASE to
/usr/local and making sure that SYBASE_OCS is unset.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler AT peppler.org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html




Archive powered by MHonArc 2.6.24.

Top of Page