Share via

SQLGetConnectOption (Visual FoxPro ODBC Driver)

  • Article

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

ODBC API conformance

Level 1.

Remarks

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.