MDAC 2.5 SDK - Visual FoxPro ODBC Driver


 

SQLSetConnectOption

Support: Partial  
ODBC API Conformance: Level 1

Sets options that govern aspects of connections. 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 SQLSetConnectOption.

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 name or fully qualified path to a directory containing zero or more free tables.
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 SQL_TXN_REAPEATABLE_READ SQL_TXN_SERIALIZABLE


For more information, see SQLSetConnectOption in the ODBC Programmer's Reference.