The ODBC Registry Wizard

Larry W Jordan Jr.
Derik Harris
Microsoft Corporation

Created: July 15, 1996
Revised: August 7, 1996

Larry W Jordan Jr. is a Senior Microsoft Access support engineer. His main focus is VBA, wizard and add-in development and Visual SourceSafe integration.

Derik Harris is a Senior Microsoft Access content engineer. His primary responsibility is writing, editing, and publishing Microsoft Access related material for the Microsoft Knowledge Base and the Microsoft Web site.

Click to open or copy the ODBCREG project files.

Overview

The ODBC Registry Wizard automates the management of the registry entries associated with the Microsoft Jet database engine. These entries are commonly referred to as “Initializing the Microsoft ODBC Database Driver.” These entries aid developers and support personnel who troubleshoot the issues involved with using ODBC access to external database applications.

Introduction

These entries are not created by any application by default, including Microsoft Access. In order to make use of these parameters,  the entries must exist in the operating system registry before starting the application that you intend to use for troubleshooting.

The additional purpose of the wizard is to make it easy for developers to include this level of troubleshooting support in the applications they ship, based upon Microsoft Access for Windows 95 version 7.0.

The Registry Entries Maintained by the Wizard

LoginTimeout

The number of seconds a login attempt can continue before timing out. The default is 20 (values are of type REG_DWORD).

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: LoginTimeout
KEY TYPE: REG_DWORD
DEFAULT VALUE: 20

QueryTimeout

The number of seconds a query can run (total processing time) before timing out. The default is 60 (values are of type REG_DWORD).

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: QueryTimeout
KEY TYPE: REG_DWORD
DEFAULT VALUE: 60

ConnectionTimeout

The number of seconds a cached connection can remain idle before timing out. The Default is 600 (values are of type REG_DWORD).

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: ConnectionTimeout
KEY TYPE: REG_DWORD
DEFAULT VALUE: 600

AsyncRetryInterval

The number of milliseconds between polls to determine if the server is finished processing a query. This entry is used for asynchronous processing only. The default is 500 (values are of type REG_DWORD).

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: AsyncRetryInterval
KEY TYPE: REG_DWORD
DEFAULT VALUE: 500

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

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: AttachCaseSensitive
KEY TYPE: REG_DWORD
DEFAULT VALUE: 0

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

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: AttachableObjects
KEY TYPE: REG_SZ
DEFAULT VALUE: 'TABLE', 'VIEW', 'SYSTEM TABLE', 'ALIAS', 'SYNONYM'

SnapshotOnly

An indicator of whether Recordset 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).

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: SnapshotOnly
KEY TYPE: REG_DWORD
DEFAULT VALUE: 0

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.

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: TraceSQLMode
KEY TYPE: REG_DWORD
DEFAULT VALUE: 0

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

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: TraceODBCAPI
KEY TYPE: REG_DWORD
DEFAULT VALUE: 0

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 0 (values are of type REG_DWORD).

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: DisableAsync
KEY TYPE: REG_DWORD
DEFAULT VALUE: 0

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

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: JetTryAuth
KEY TYPE: REG_DWORD
DEFAULT VALUE: 1

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.

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: PreparedInsert
KEY TYPE: REG_DWORD
DEFAULT VALUE: 1

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.

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: PreparedUpdate
KEY TYPE: REG_DWORD
DEFAULT VALUE: 0

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)

Parameter Details

HKEY LOCATION: Software\Microsoft\Jet\3.0\Engines\ODBC
KEY VALUE: FastRequery
KEY TYPE: REG_DWORD
DEFAULT VALUE: 0

Conclusion

The Windows Registry can be used to tune the operation of the ODBC driver. If your application can't accept the default behavior of the drivers,  the ODBC Registry Wizard makes it easy to override the default settings to get the appropriate behavior from your application.