For the following functions, the new driver adheres to a different level of ODBC API conformance than the old driver:
- SQLExecute and SQLExecDirect, when no rows are affected by the statement.
When a statement affects 0 rows, the old driver returns SQL_SUCCESS. The new driver returns SQL_SUCCESS when using ODBC 2.x, and returns SQL_NO_DATA when using ODBC 3.x.
For more information, see "SQL_NO_DATA" in the ODBC Programmers' Reference: https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/sql-no-data.
- SQLPrepare, SQLExecute, and SQLExecDirect, when an empty statement is passed in.
When an empty SQL statement is passed into SQLPrepare, SQLExecute, or SQLExecDirect, the old driver returns SQL_SUCCESS. The new driver returns SQL_ERROR with SQLState 42000.