FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

On Tue, 25 Jan 2000, Peter Zeltins wrote:

> 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
> 
Can you set TDSDUMP (such as 'export TDSDUMP=/tmp/freetds.log') and post
the output? 

BTW, the unknown property messages have been removed in the CVS versions.

Brian