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. |