Skip to Content.
Sympa Menu

freetds - Re: [freetds] Prepared statement + date fields

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Prepared statement + date fields
  • Date: Fri, 02 Jun 2006 09:51:19 +0200

Il giorno gio, 01/06/2006 alle 13.05 +0200, KERTEL - Maxime MARAIS ha
scritto:
> Hello,
>
> Programming Perl scripts connecting to MS-SQL Databases and able to be
> ran on both Linux and Windows plateforms (using [DBD::Sybase+FreeTDS] on
> Linux and [DBD::ODBC+MSSQL driver] on Windows), I try to use
> $dbh->prepare($sql) and $sth->execute($values) statements.
> My scripts work fine on Windows plateform but I am unable to run them on
> Linux because of a segmentation fault fired when executing
> $dbh->prepare($sql). It seems FreeTDS does not support the placeholder
> functionality when ODBC does (ie. "SELECT * FROM MyTable WHERE MyData = ?").
>

...

Hi,
why don't you use DBD::OBDC even on Linux? Placeholders should work
correctly on 0.64 using Ctlib (that is DBD::Sybase) while they works
well on 0.63 ODBC. If you want to use 0.63 consider patch at
http://freetds.sourceforge.net/ while I would suggest 0.64 (even if
still rc).

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page