ODBC Engine Settings

The registry settings described in the following table are located in the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\ODBC key of the Windows registry. They are not installed by any Microsoft ODBC client applications. As users can do with many of the Microsoft Jet registry settings, they can change the default behavior by creating the appropriate keys and settings, and then setting values accordingly.

Setting Data type Default value Description
LoginTimeout Integer 20 Number of seconds to wait for a login attempt to succeed.
QueryTimeout Integer 60 Number of seconds to wait for a query to execute before failing.
ConnectionTimeout Integer 600 Number of seconds to wait before closing an idle connection.
AsyncRetryInterval Integer 500 Number of milliseconds to wait between retries on an asynchronous connection.
AttachCaseSensitive Boolean 0 If False (0), will attach to the first name matching the specified string in a match that isn’t case-sensitive. If True (1), requires a case-sensitive match of the name.
AttachableObjects String TABLE The list of objects that Microsoft Jet will allow attachments to (TABLE, NEW, SYSTEMTABLE, ALIAS, SYNONYM). Values are of type REG_SZ.
SnapshotOnly Boolean 0 If False (0), you will get index information on attachment to allow dynasets if possible. If True (1), Microsoft Jet will ignore index information and thereby force snapshots on all attachments.
TraceSQLMode Boolean 0 Initiates sending a trace of SQL statements sent to an ODBC data source to the file Sqlout.txt. Values are 0 (False) and 1 (True). Values are of type REG_DWORD. This setting is interchangeable with SQLTracemode.
TraceODBCAPI Boolean 0 Initiates sending a trace of ODBC API calls to the file Odbcapi.txt. Values are 0 (False) and 1 (True). Values are of type REG_DWORD.
DisableAsync Boolean 0 Forces synchronous query execution. Values are 0 (use asynchronous query execution if possible) and 1 (force synchronous query execution). Values are of type REG_DWORD.
TryJetAuth Boolean 1 Uses the Microsoft Access user name and password to log on to the server before prompting. Values are 0 (False) and 1 (True). Values are of type REG_DWORD.

Setting Data type Default value Description
PreparedInsert Boolean F Uses a prepared INSERT statement that inserts data in all columns. Values are 0 (use a custom INSERT statement that inserts only non-Null values) and 1 (use a prepared INSERT statement). Values are of type REG_DWORD.

Using prepared INSERT statements can cause Null values to overwrite server defaults and can cause triggers to execute on columns that weren’t inserted explicitly.

PreparedUpdate Boolean F Uses a prepared UPDATE statement that updates data in all columns. Values are 0 (use a custom UPDATE statement that sets only columns that have changed) and 1 (use a prepared UPDATE statement). Values are of type REG_DWORD.

Using prepared UPDATE statements can cause triggers to execute on columns that weren’t changed explicitly.

FastRequery Boolean F Uses a prepared SELECT statement for parameterized queries. Values are 0 (False) and 1 (True). Values are of type REG_DWORD.