[freetds] SQLRowCount failing after prepare and execute

James K. Lowden jklowden at schemamania.org
Fri Feb 13 20:45:49 EST 2004


On Fri, 13 Feb 2004, "Matthew A. Davis" <azami at speakeasy.net> wrote:
> Frediano Ziglio wrote:
> > delete, insert and update have the same behavior... if you use
> > SQLPrepare with sql server you are not able to get row count.
> 
> it works with every ODBC driver and database we've used, including SQL
> Server on Windows.  And, in the freeTDS log, I can see rows_affected
> being set to the correct value during DONEINPROC 

I think he's got you there, Freddy!  ;-)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_odbc_p_3ysl.asp

You might have been thinking of the note at the bottom:

Note  If SET NOCOUNT ON has been executed, multiple statements embedded in
a stored procedure do not create multiple result sets as they should. Row
counts generated by SQL statements inside a stored procedure are ignored
by the driver.

--jkl




More information about the FreeTDS mailing list