MDAC 2.5 SDK - ODBC Desktop Database Drivers


 

SQLSetConnectOption

fOption Comment
SQL_ACCESS_MODE The SQL_ACCESS_MODE fOption can be set to either SQL_MODE_READ_ONLY or SQL_MODE_READ_WRITE. However, the driver does not prevent updates if SQL_ACCESS_MODE is set to SQL_MODE_READ_ONLY.
SQL_AUTOCOMMIT The dBASE driver only supports SQL_AUTOCOMMIT being set to ON (the default state), because it does not support transactions.
SQL_CURRENT_QUALIFIER Supported.
SQL_LOGIN_TIMEOUT Not supported.
SQL_OPT_TRACE Supported.
SQL_OPT_TRACEFILE Supported.
SQL_PACKET_SIZE Not supported.
SQL_QUIET_MODE Not supported.
SQL_TRANSLATE_DLL Not supported.
SQL_TRANSLATION_OPTION Not supported.
SQL_TXN_ISOLATION Not supported.