[freetds] SQLPrepare, SQL Execute fails on SQL 7 but works on SQL 2K

ZIGLIO Frediano Frediano.Ziglio at vodafone.com
Mon Sep 22 18:24:54 EDT 2003


> 
> The calls used UnixODBC and our own "wrapper" on top of that. 
>  Our wrapper would throw C++ errors IF an error was 
> encountered.  We seem to be getting an error from the 
> SQLPrepare, as you can see, but it isn't getting returned as 
> an error from FreeTDS/UnixODBC.  What is strange is that this 
> works fine on SQL2K, but seems to throw a server-side syntax 
> error under SQL 7 when calling sp_prepare.  All prepared 
> statements on SQL 7 fail with a syntax error, but only when 
> called from FreeTDS/UnixODBC.
> 
> I haven't been able to reproduce the problem with msodbc.
> 

Try replacing src/tds/query.c with file attached (zipped)

freddy77


More information about the FreeTDS mailing list