MDAC 2.5 SDK - ODBC Desktop Database Drivers


 

SQLSetStmtOption

fOption Comments
SQL_ASYNC_ENABLE Asynchronous processing is not supported. The SQL_ASYNC_ENABLE fOption will return SQLSTATE S1C00 (Driver not capable).
SQL_KEYSET_SIZE The only valid keyset size is 0, because mixed and dynamic cursors are not supported. If this value is set to any other number, it will be changed to 0 and the call will return SQL_SUCCESS_WITH_INFO and SQLSTATE 01S02 (Option value changed).
SQL_MAX_ROWS The only valid rowset size is 0, because the Desktop Database Drivers do not support limiting the number of rows that are returned. If this value is set to any other number, it will be changed to 0 and the call will return SQL_SUCCESS_WITH_INFO and SQLSTATE 01S02 (Option value changed).
SQL_QUERY_TIMEOUT Not supported.
SQL_ROW_NUMBER Not supported.
SQL_SIMULATE_CURSOR Not supported.