freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: KERTEL - Maxime MARAIS <mmarais AT kertel.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: [freetds] DBD::ODBC + FreeDTS fails
- Date: Fri, 16 Jun 2006 14:29:02 +0200
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] DBD::ODBC + FreeDTS fails,
KERTEL - Maxime MARAIS, 06/16/2006
- Re: [freetds] DBD::ODBC + FreeDTS fails, Daniel Kasak, 06/22/2006
- <Possible follow-up(s)>
- Re: [freetds] DBD::ODBC + FreeDTS fails, ZIGLIO, Frediano, VF-IT, 06/23/2006
- Re: [freetds] DBD::ODBC + FreeDTS fails, Patrick Gu, 06/23/2006
Archive powered by MHonArc 2.6.24.