Implicit Cursor Conversions (ODBC)
Applications can request a cursor type through SQLSetStmtAttr and then execute an SQL statement that is not supported by server cursors of the type requested. A call to SQLExecute or SQLExecDirect returns SQL_SUCCESS_WITH_INFO and SQLGetDiagRec returns:
szSqlState = "01S02", *pfNativeError = 0,
szErrorMsg="[Microsoft][SQL Native Client]Cursor type changed"
The application can determine what type of cursor is now being used by calling SQLGetStmtOption set to SQL_CURSOR_TYPE. The cursor type conversion applies to only one statement. The next SQLExecDirect or SQLExecute will be done using the original statement cursor settings.
See Also
Concepts
Cursor Programming Details (ODBC)
Other Resources
Using Implicit Cursor Conversions