FreeTDS Development Group

["Peter Zeltins" <peterz AT umpire.com>]

Seems like I've found a bug in FreeTDS libs as the following SQL statement executes OK under 0.47 but breaks up under 0.50:

 

$dbh->do("execute MyProc \@parm1=\'$arg1\',\@parm2=\'$arg2\',\@parm3=$arg3,\@parm4=$arg4,\@parm5=$arg5")

 

$arg... does not contain any quotes. parm3..5 are numeric, parm1..2 are string.

 

SQL server trace shows the following SQL was passed to server:

 

execute MyProc @parm1='arg1val

 

Quite naturally, this produces SQL server error message about unclosed quote.

 

It is RedHat 6.1 system, Perl 5.005_03, DBI 1.13, DBD::Sybase 0.21 connecting to MSSQL 7.0 server. I've tried compiling 0.50 both with tdsver=4.2 and 7.0 options, and tried latest CVS version as well. Am I missing something here?

 

Also, is there any way I can turn off "Unknown property" messages? I know these are (usually) harmless, but under Apache it fills up errorlog.

 

Peter