SQLGetConnectOption (Visual FoxPro ODBC Driver)
Note
This article contains Visual FoxPro ODBC Driver-specific information. For general information about this function, see the appropriate article under ODBC API Reference.
Support: Partial
Level 1.
Returns the current setting of a connection option. This function is partially supported: the driver supports all values for the fOption
argument but doesn't support some of vParam
values for the fOption
argument SQL_TXN_ISOLATION
.
The following table describes only those arguments with behavior specific to the Visual FoxPro ODBC Driver implementation of SQLGetConnectOption
.
fOption |
Remarks |
---|---|
SQL_AUTOCOMMIT |
If you choose SQL_AUTOCOMMIT_OFF , your application must explicitly commit or roll back transactions with SQLTransact; the Visual FoxPro ODBC Driver doesn't automatically commit a transactable statement upon completion. The driver does begin a transaction if the statement is transactable. |
SQL_CURRENT_QUALIFIER |
Can be a fully qualified database (.dbc file) name or fully qualified path to a directory containing zero or more tables (.dbf files). |
SQL_LOGINTIMEOUT |
Returns Driver Not Capable error. |
SQL_CURSORS |
Returns Driver Not Capable error. |
SQL_PACKET_SIZE |
Returns Driver Not Capable error. |
SQL_TXN_ISOLATION |
The driver allows only SQL_TXN_READ_COMMITTED .The following vParam values aren't supported:SQL_TXN_READ_UNCOMMITTED SQL_TXN_REAPEATABLE_READ SQL_TXN_SERIALIZABLE |
For more information, see SQLGetConnectOption Function in the ODBC Programmer's Reference.