Skip to Content.
Sympa Menu

freetds - Re: [freetds] DBD::ODBC + FreeDTS fails

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Patrick Gu" <Patrick.Gu AT Ticketmaster.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] DBD::ODBC + FreeDTS fails
  • Date: Fri, 23 Jun 2006 10:22:47 -0700

Have you tried to set this in your shell?

export PERL_DL_NONLAZY=1

-Patrick

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of KERTEL - Maxime
MARAIS
Sent: Friday, June 16, 2006 5:29 AM
To: FreeTDS Development Group
Subject: [freetds] DBD::ODBC + FreeDTS fails

Hi all,

I am trying to use dbi::ODBC instead of dbi::Sybase in Perl scripts (I
use FreeTDS as a driver to connect to an MS-SQL Server 2000). The aim is
to be able to use placeholders (ex. "SELECT * FROM PERSONS WHERE NAME =
? AND ACTIVE = 1") as it fails when trying to prepare statements with
dbi::Sybase, displaying a segmentation fault. (I already wrote about
this a few days/weeks ago).

I installed unixODBC, set up odbc.ini, and performed a few successfull
requests using isql to get connected to the database I plan to use with
my Perl scripts.

Now, I plan to install DBD::ODBC. I exported DBI_DSN ('dbi:ODBC:<dsn>'),
DBI_USER ('sa'), DBI_PASS ('****'), ODBCHOME ('/var'), ran successfully
`perl Makefile.PL`, `make` but did not pass `make test`. The tests fails
when running t/20SqlServer with the following error :

DBD::ODBC::st execute failed: (DBD: st_execute/SQLExecute err=-1) at
t/20SqlServer.t line 210.

I ignored the problem and installed anyway in order to see if it could
work with my perl script. But it also fails with the error `(DBD:
st_prepare/SQLPrepare err=-1)`. I try to run a simple select query.

Any idea ?

Regards.


--
Maxime MARAIS
Kertel.

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page