MDAC 2.5 SDK - Visual FoxPro ODBC Driver
Support: Partial
ODBC API Conformance: 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 does not 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 does not 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 vParams are not supported: SQL_TXN_READ_UNCOMMITTED |
For more information, see SQLGetConnectOption in the ODBC Programmer's Reference.