The SQLSetConnectOption function allows the caller to set options that govern aspects of the connection.
The following cursor related options are supported.
| Option | Value |
|---|---|
| SQL_ODBC_CURSORS | SQL_CUR_USE_IF_NEEDED SQL_CUR_USE_ODBC SQL_CUR_USE_DRIVER |
| SQL_TXN_ISOLATION | SQL_TXN_READ_UNCOMMITTED SQL_TXN_READ_COMMITTED SQL_TXN_REPEATABLE_READ SQL_TXN_SERIALIZABLE The SQL_TXN_VERSIONING option is not supported. (In SQL Server, repeatable read is treated as serializable.) |
| Driver specific option | SQL_PRESERVE_CURSORS allows you to choose between closing or preserving the cursor state across transaction commits/rollbacks. The default is to close cursors on a transaction commit/rollback. |