Edit

Share via

Connect Options

  • Article

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.