INF: -T3640 Flag May Block Updates to an ODBC Application

MORE INFORMATION

In an ODBC application using the Microsoft ODBC SQL Server Driver to communicate with a SQL Server that is running with the -T3640 flag enabled, the ODBC API call, SQLRowCount(), will not be able to provide the number of rows affected after a statement is prepared as a procedure using SQLPrepare() and then executed using SQLExecute.

The effect is that in some ODBC-enabled applications, such as Microsoft Access, when updates are attempted on a SQL Server table that resides on a SQL Server running the -T3640 flag, the update will fail with the error:

No other error message will be returned.

With the -T3640 flag enabled, SQL Server is unable to return the number of rows updated in response to the ODBC API call SQLRowCount(). Other ODBC- enabled applications, whose proper operation depend the number of rows affected by an ODBC SQL query returning from SQLRowCount(), will encounter similar problems. However, if the -T3640 flag is not used, this problem will not occur.