Connect Options
Important
This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use the ODBC driver provided by Oracle.
These options allow customization of the database connection within an application.
| Connect option | Notes |
|---|---|
| SQL_AUTOCOMMIT | If you choose SQL_AUTOCOMMIT_OFF, your application must explicitly commit or roll back transactions with SQLTransact. |
| SQL_ODBC_CURSORS | This connection attribute is implemented in the Driver Manager. |
| SQL_OPT_TRACE | This connection attribute is implemented in the Driver Manager. |
| SQL_OPT_TRACEFILE | This connection attribute is implemented in the Driver Manager. |
| SQL_TRANSLATE_DLL | Returns error: "Driver not capable." |
| SQL_TRANSLATE_OPTION | A 32-bit value passed to the translation .dll. |
| SQL_TXN_ISOLATION | The driver allows only SQL_TXN_READ_COMMITTED. The following vParams are not supported: SQL_TXN_READ_UNCOMMITTED SQL_TXN_REAPEATABLE_READ SQL_TXN_SERIALIZABLE |
| SQL_ATTR_ENLIST_IN_DTC | This ODBC 3.0 connection attribute allows you to use the ODBC Driver for Oracle in distributed transactions coordinated by Microsoft Component Services (or MTS, if you are using Windows NT). It provides the interface pointer pITransaction to the transaction as the vParam argument. |
| SQL_ATTR_CONNECTION_DEAD | This read-only ODBC 3.5 connection attribute allows you to determine whether the connection to the Oracle server has failed. Get only; cannot Set. |