FreeTDS Development Group

[KERTEL - Maxime MARAIS <mmarais AT kertel.com>]

Frediano Ziglio a écrit :
> 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? 

Hello,

I do not use OBDC as I can't find free open source driver for MS-SQL 
uneder Linux (except FreeTDS). Other solutions exist (like ODBC to ODBC 
bridges) but I prefer using as few components as possible.

Finaly, I modified my code and do not use placeholders anymore, even if 
this can be less secure or require more string manipulation in order to 
escape user input and prevent miscallaneous code execution.


> 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).

Could you tell me more about using ODBC + Ctlib? I would like to have a 
look to this solution for future usages.

Thanks.

--
Maxime MARAIS
Kertel.