Configure Microsoft Jet Database Engine for ODBC Access
The following sections describe the Microsoft Jet database engine for connecting the Microsoft® Windows® Registry Settings for the ODBC database.
Initialization settings for Microsoft Jet connecting ODBC databases
The /hkey_local_machine/software/microsoft/jet/4.0/Engines/odbc folder contains the initialization settings for the Microsoft Jet database engine.
Note The example below shows the typical settings in the Jet / 4.0 / Engines / ODBC folder.
Logintimeout = 20
QueryTimeout = 60
ConnectionTIMEOUT = 600
AsyncRETRYINTERVAL = 500
Attachcasensensitive = 0
AttachableObjects = 'Table', 'View', 'System Table', 'Alias', 'Synynym'
Snapshotonly = 0
Tracesqlmode = 0
TRACEODBCAPI = 0
Disableasync = 1
TRYJETAUTH = 1
PreparedInsert = 0
PreparedUpdate = 0
FastReQuery = 0
Fatblastrows = -1
FatBlastTimeout = 3
Odbcisamattach = 0
The Microsoft Jet Database Engine uses the ODBC item as shown below.
item
Description
Logintimeout
Login attempts can continue at the timeout. The default is 20 (the value is the REG_DWORD type).
QueryTimeout
Query the number of seconds that can be run before the timeout (total processing time). If disableasync = 0 (default setting), QueryTimeout is the number of seconds required to wait for the server response between each polling query. The default is 60 (the value is the REG_DWORD type).
ConnectionTIMEOUT
The cache can be kept idle before the timeout. The default is 600 (the value is the REG_DWORD type).
AsyncRETRYINTERVAL
Used to determine if the server has completed the number of milliseconds between each rotation of the query processing. This item is only used for asynchronous processing. The default is 500 (the value is the REG_DWORD type).
AttachCaseSensitive
Indicator determines whether the table name is fully matched. The value is 0 (the first table that matches the specified name, regardless of case) and 1 (linked table only when the name is fully matched). The default is 0 (the value is the REG_DWORD type).
AttachableObjects
Allows a list of server object types that links to them. The default is: "Table", "View", "System Table", "Alias", "Synynym" (value is REG_SZ type).
Snapshotonly
Indicator determines whether to force the recordset object to become a snapshot type. The value is 0 (allowing Dynaset) and 1 (forced snapshot). The default is 0 (the value is the REG_DWORD type).
TraceSQLMODE
The indicator determines whether the Microsoft Jet database engine tracks the SQL statement of the ODBC data source sent to SQLOUT.TXT. The value is 0 (no) and 1 (yes). The default is 0 (the value is the REG_DWORD type). This item can be exchanged with SQLTraceMode. TRACEODBCAPI
The indicator determines whether to track the ODBC API call in odbcapi.txt. The value is 0 (no) and 1 (yes). The default is 0 (the value is the REG_DWORD type).
Disableasync
Indicator determines whether to force synchronous queries. The value is 0 (if possible, use asynchronous query execution) and 1 (forced synchronous query). The default is 1 (value of the REG_DWORD type).
TryjetAuth
The indicator determines if it is tried using the Microsoft Access username and password to log in to the server before getting prompt. The value is 0 (no) and 1 (yes). The default is 1 (value of the REG_DWORD type).
PreparedInsert
The indicator determines whether to insert data in all columns using the ready-made INSERT statement. A value of 0 (using only a non-NULL value) and 1 (using the ready-made INSERT statement). The default is 0 (the value is the REG_DWORD type).
Using a ready-to-list, it can cause NULL override the server default value, and can cause the trigger to be performed for columns not explicitly inserted.
PreparedUpdate
The indicator determines whether to use the ready UPDATE statement to update the data in all columns. The value is 0 (using only a custom UPDATE statement that only changes the changed column) and 1 (using the ready-to-UPDATE statement). The default is 0 (the value is the REG_DWORD type).
Using the ready-to-date statement can cause the trigger to be executed for unmeated columns.
FastRequery
The indicator determines whether to use the parameterized query to use the ready-to-SELECT statement. The value is 0 (no) and 1 (yes). The default is 0 (the value is the REG_DWORD type).
Fatblastrows
FatBlastTimeout
Odbcisamattach
Note When you change the Windows Registry Setup, you must quit the database engine before restarting it, so that new settings take effect.
Remarks: From MSDN
