BUG: SQLRowCount Does Not Return Number of Affected Rows in Stored Procedure

ID: Q187350

The information in this article applies to:

Microsoft SQL Server version 6.5
Microsoft ODBC Driver for SQL Server, version 3.5

SYMPTOMS

If any data is modified, updated, or inserted into a table which is contained in a stored procedure, the SQLRowCount function does not return the number of affected rows. It returns a value of -1.

WORKAROUND

To correctly return the number of rows affected, use the @@ROWCOUNT variable in the stored procedure.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in the latest driver 3.60.0310 available with ODBC3.5SDK. A supported fix is now available, but has not been fully regression-tested and should be applied only to systems experiencing this specific problem. Unless you are severely impacted by this specific problem, Microsoft recommends that you wait for the next Service Pack that contains this fix. Contact Microsoft Technical Support for more information.

Additional query words: ODBC

Keywords : SSrvProg kbbug6.50
Version : WINDOWS:3.5; winnt:6.5
Platform : WINDOWS winnt
Issue type : kbbug