ACC95: How to Add Former MSACC20.INI ODBC Section to Registry
ID: Q139044
|
The information in this article applies to:
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat).
SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills.
When troubleshooting ODBC connection issues or optimizing client/server
performance, you often need to modify the ODBC settings in the ODBC section
of the MSACC20.INI (or MSACCESS.INI in version 1.x). However, in Microsoft
Access for Windows 95 version 7.0, a series of default values are pre-set.
To force Microsoft Access to accept user-defined values for the ODBC
settings, you need to add an ODBC Key and subsequent values to the Windows
95 Registry.
MORE INFORMATION
The \HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.0\Engines\ODBC
folder contains initialization settings for the Microsoft Jet database
engine. Before you can add any of the following values to the registry, you
must create the ODBC folder under the Jet\3.0\Engines folder.
NOTE: Examples below are provided for both Windows 95 and Windows NT.
For Windows 95
For information about how to edit the registry, view the Changing Keys And
Values online Help topic in Registry Editor (Regedit.exe). Note that you
should make a backup copy of the registry files (System.dat and User.dat)
before you edit the registry.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Windows 95. Microsoft cannot guarantee that
problems resulting from the incorrect use of Registry Editor can be solved.
Use Registry Editor at your own risk.
- Click the Start button, and then click Run.
- In the Open box, type regedit.
- Locate the HKEY_LOCAL_MACHINE registry folder.
- Expand the HKEY_LOCAL_MACHINE folder until you locate the
SOFTWARE\Microsoft\Jet\3.0\Engines folder.
- Click Engines.
- On the Edit Menu in the Registry Editor, click New, and then click
Key.
- Type ODBC, and then press ENTER.
- The following values can be created under the ODBC folder:
Name Type Default Value
------------------- ------ -----------------------------
LoginTimeout DWORD 20
QueryTimeout DWORD 60
ConnectionTimeout DWORD 600
AsyncRetryInterval DWORD 500
AttachCaseSensitive DWORD 00 (False)
AttachableObjects String 'TABLE','VIEW','SYSTEM TABLE',
'ALIAS','SYNONYM'
SnapshotOnly DWORD 00 (False)
TraceSQLMode DWORD 00 (False)
TraceODBCAPI DWORD 00 (False)
DisableAsync DWORD 00 (False)
TryJetAuth DWORD 01 (True)
PreparedInsert DWORD 00 (False)
PreparedUpdate DWORD 00 (False)
FastRequery DWORD 00 (False)
- To add a new value, make sure that the ODBC key is highlighted, click
the Edit menu, and then click New. On the menu that appears, you will
see three Value Type choices: String, Binary, and DWORD. Click the type
you want.
- A new value will be created in the right pane of the Registry window.
Type in a new name for the value and press ENTER.
- With the new value still highlighted, click the Edit menu and click
Modify. Type the new data for the value you have just created and click
OK.
For Windows NT 3.51
For information about how to edit the registry, view the Changing Keys And
Values online Help topic in Registry Editor (Regedit.exe). Note that you
should make a backup copy of the registry files (System.dat and User.dat)
before you edit the registry.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Windows 95. Microsoft cannot guarantee that
problems resulting from the incorrect use of Registry Editor can be solved.
Use Registry Editor at your own risk.
- In Program Manager, select File, Run.
- Type regedt32.
- Locate the HKEY_LOCAL_MACHINE registry folder.
- Expand the HKEY_LOCAL_MACHINE folder until you locate
SOFTWARE\Microsoft\Jet\3.0\Engines folder.
- Click Engines.
- From the Edit Menu in the Registry Editor, click Add Key.
- Type ODBC and press ENTER.
- The following values can be created under the ODBC folder using the
Edit Menu option Add Value:
Name Type Default Value
------------------- --------- -----------------------------
LoginTimeout REG_DWORD 20
QueryTimeout REG_DWORD 60
ConnectionTimeout REG_DWORD 600
AsyncRetryInterval REG_DWORD 500
AttachCaseSensitive REG_DWORD 00 (False)
AttachableObjects REG_SZ 'TABLE','VIEW','SYSTEM TABLE',
'ALIAS','SYNONYM'
SnapshotOnly REG_DWORD 00 (False)
TraceSQLMode REG_DWORD 00 (False)
TraceODBCAPI REG_DWORD 00 (False)
DisableAsync REG_DWORD 00 (False)
TryJetAuth REG_DWORD 01 (True)
PreparedInsert REG_DWORD 00 (False)
PreparedUpdate REG_DWORD 00 (False)
FastRequery REG_DWORD 00 (False)
- To add a new value, make sure that the ODBC key is highlighted, click
the Edit menu, and then click Add Key. Enter the name of the key in the
Value Name text field, and then select the appropriate DataType from
the above list.
- A new value will be created in the right pane of the Registry window.
Type in a new name for the value and press ENTER.
- With the new value still highlighted, double-click the entry to modify
the value.
REFERENCES
For more information about ODBC Registry Settings, search on the phrase
"ODBC," and then view "Initializing the Microsoft ODBC Database Driver"
using the Answer Wizard from the Microsoft Access for Windows 95 Help menu.
Keywords : kbusage OdbcHowto
Version : 7.0
Platform : WINDOWS
Issue type : kbhowto
|