[freetds] DBD::ODBC + FreeDTS fails

KERTEL - Maxime MARAIS mmarais at kertel.com
Fri Jun 16 08:29:02 EDT 2006


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.




More information about the FreeTDS mailing list