Attribute |
Definition |
Syntax |
AutoCommit |
Specifies whether to use auto-commit or manual-commit mode. |
connectionname.AutoCommit [= constant] These are the possible values for constant: �
SQL_AUTOCOMMIT_OFF The connection uses manual-commit mode. The application must explicitly commit or roll back a transaction with the Commit or Rollback methods. � SQL_AUTOCOMMIT_ON The driver uses auto-commit mode. Each command is committed immediately after it is executed. � SQL_AUTOCOMMIT_DEFAULT. Autocommit On. If no value for constant is assigned, the default depends on the settings in your ODBC setup. Changing from manual-commit mode to auto-commit mode commits any open transactions on the connection. |
AccessMode |
Retrieves or assigns an integer value indicating the ODBC access mode of a connection. |
connectionname.AccessMode [= constant] These are the possible values for constant: �
SQL_MODE_READ_WRITE Connections may process any read or write requests submitted. � SQL_MODE_READ_ONLY Connections will be instructed not to process requests which are not read-only; the behavior of the data source and ODBC driver which receive such requests is defined by the implementation. � SQL_MODE_DEFAULT. Read-write access mode. The default value for this attribute is SQL_MODE_READ_WRITE. |
CurrentQualifier |
Specifies the concurrency attribute, which is a string containing the SQL command qualifier to be used by the data source. |
connectionname.CurrentQualifier [= qualifier] For some databases the qualifier string might indicate a database to access, or in the case of some file-based data sources, a directory where table files are stored. Either can be specified. |
ODBCCursors |
Specifies how the connection will use the ODBC cursor library. |
connectionname.ODBCCursors [= constant] These are the possible values for constant: �
SQL_CUR_USE_IF_NEEDED The connection uses the ODBC cursor library only if it is needed. If Move and Find methods are not supported by the ODBC data source, the ODBC driver manager will attempt to emulate them. � SQL_CUR_USE_ODBC The connection uses the ODBC cursor library. � SQL_CUR_USE_DRIVER The connection uses the cursors and scrolling capabilities of the driver. Move and Find methods are driven using the data source's cursor model. � SQL_CUR_USE_DEFAULT. Use driver-driven cursors. The default value for this attribute is SQL_CUR_USE_DRIVER. |
LoginTimeout |
Specifies an integer value indicating the number of seconds to wait for a login request to complete. The default is data source-driver dependent and is always a non-zero integer. If LoginTimeout is assigned 0, the timeout is disabled and a connection will wait indefinitely while attempting to log in. |
connectionname.LoginTimeout [= logintimeout] The default login timeout for the connection is SQL_LOGIN_TIMEOUT_DEFAULT. |
OptTraceFile |
Specifies the name of the ODBC trace file. |
connectionname.OptTraceFile [ = filename] filename can be any valid string expression that is a valid file system path. |
OptTrace |
Specifies an integer value indicating whether the ODBC Driver Manager performs tracing. |
connectionname.OptTrace [= constant] These are the possible values for constant: �
SQL_OPT_TRACE_OFF - tracing off � SQL_OPT_TRACE_ON - tracing on � SQL_OPT_TRACE_DEFAULT - tracing off. An application specifies a trace file with the OptTraceFile attribute. If the file already exists, the ODBC Driver Manager appends to the file. If the trace file does not exist, the ODBC Driver Manager creates the file. If no tracing file has been specified, the ODBC Driver
Manager writes to the file \SQL.LOG. The default value for this attribute is SQL_OPT_TRACE_OFF, which indicates that no ODBC tracing will occur. |
PacketSize |
An integer value that specifies the network packet size in bytes.  Note Many data sources do not support this attribute. |
connectionname.PacketSize [= size] |
QuoteChar |
Retrieves the data source-specific quote character. This attribute is read only at runtime. |
connectionname.QuoteChar |
TranslateDLL |
Specifies the name of the DLL containing ODBC translation functions. |
connectionname.TranslateDLL [= DLLname] DLLname can be any valid string expression that is a valid file system path to the translation DLL file. The translation DLL provides a facility for implementing additional translation functionality, including character set translation. |
TxnIsolation |
Retrieves or assigns an integer value indicating the ODBC transaction isolation level. The following definitions and behaviors are defined in ODBC: � Dirty Read Transaction1 modifies a row and Transaction2 reads the modified row before Transaction1 commits the change. If Transaction1 rolls back the change, Transaction2 will have read a row that should have never existed. � Nonrepeatable Read Transaction1 reads a row and Transaction2 updates or deletes that row and commits this change. If Transaction1 rereads the row, it will receive different values or discover that the row no longer exists. � Phantom Transaction1 reads a set of rows that satisfy some search criteria. Transaction2 inserts a row that matches the search criteria. If Transaction1 re-executes the query that reads the rows, it receives a different set of rows. |
connectionname.Txnlsolation [= constant] These are the possible values for constant: �
SQL_TXN_READ_UNCOMMITTED Dirty reads, nonrepeatable reads, and phantoms are possible. � SQL_TXN_READ_COMMITTED Dirty reads are not possible. Nonrepeatable reads and phantoms are
possible. � SQL_TXN_REPEATABLE_READ Dirty reads and nonrepeatable reads are not possible. Phantoms are possible. � SQL_TXN_SERIALIZABLE Transactions are serializable. Dirty reads, nonrepeatable reads, and
phantoms are not possible. � SQL_TXN_VERSIONING. Transactions are serializable, but higher concurrency is possible than with SQL_TXN_SERIALIZABLE. Dirty reads are not possible. |
