The \HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.5\Engines\ODBC folder contains initialization settings for the Microsoft Jet database engine.
Note Typical settings for the entries in the Jet\3.5\Engines\ODBC folder are shown in the following example.
LoginTimeout=20
QueryTimeout=60
ConnectionTimeout=600
AsyncRetryInterval=500
AttachCaseSensitive=0
AttachableObjects='TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'
SnapshotOnly=0
TraceSQLMode=0
TraceODBCAPI=0
DisableAsync=1
JetTryAuth=1
PreparedInsert=0
PreparedUpdate=0
FastRequery=0
The Microsoft Jet database engine uses the ODBC entries as follows.
| Entry | Description |
| LoginTimeout | The number of seconds a login attempt can continue before timing out. The default is 20 (values are of type REG_DWORD). |
| QueryTimeout | The number of seconds a query can run (total processing time) before timing out. If DisableAsync=1 (the default), then QueryTimeout is the number of seconds to wait for a response from the server between polls for query completion. The default is 60 (values are of type REG_DWORD). |
| ConnectionTimeout | The number of seconds a cached connection can remain idle before timing out. The default is 600 (values are of type REG_DWORD). |
| AsyncRetryInterval | The number of milliseconds between polls to determine if the server is done processing a query. This entry is used for asynchronous processing only. The default is 500 (values are of type REG_DWORD). |
| AttachCaseSensitive | An indicator of whether to match table names exactly when linking. Values are 0 (link the first table matching the specified name, regardless of case) and 1 (link a table only if the name matches exactly). The default is 0 (values are of type REG_DWORD). |
| AttachableObjects | A list of server object types to which linking will be allowed. The default is: 'TABLE', 'VIEW', 'SYSTEM TABLE', 'ALIAS', 'SYNONYM' (values are of type REG_SZ). |
| SnapshotOnly | An indicator of whether CdbRecordset objects are forced to be of snapshot type. Values are 0 (allow dynasets) and 1 (force snapshots only). The default is 0 (values are of type REG_DWORD). |
| TraceSQLMode | An indicator of whether the Microsoft Jet database engine will trace SQL statements sent to an ODBC data source in SQLOUT.txt. Values are 0 (no) and 1 (yes). The default is 0 (values are of type REG_DWORD). This entry is interchangeable with SQLTraceMode. |
| TraceODBCAPI | An indicator of whether to trace ODBC API calls in ODBCAPI.txt. Values are 0 (no) and 1 (yes). The default is 0 (values are of type REG_DWORD). |
| DisableAsync | An indicator of whether to force synchronous query execution. Values are 0 (use asynchronous query execution if possible) and 1 (force synchronous query execution). The default is 1 (values are of type REG_DWORD). |
| JetTryAuth | An indicator of whether to try using the Microsoft Access user name and password to log in to the server before prompting. Values are 0 (no) and 1 (yes). The default is 1 (values are of type REG_DWORD). |
| PreparedInsert | An indicator of whether to use 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). The default is 0 (values are of type REG_DWORD).
Using prepared INSERT statements can cause Nulls to overwrite server defaults and can cause triggers to execute on columns that weren't inserted explicitly. |
| PreparedUpdate | An indicator of whether to use 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). The default is 0 (values are of type REG_DWORD).
Using prepared UPDATE statements can cause triggers to execute on unchanged columns. |
| FastRequery | An indicator of whether to use a prepared SELECT statement for parameterized queries. Values are 0 (no) and 1 (yes). The default is 0 (values are of type REG_DWORD). |
Note When you change Windows Registry settings, you must exit and then restart the database engine for the new settings to take effect.