ACC2000: OpenDatabase Method Does Not Use Jet LoginTimeoutID: Q202037
|
The default ODBC Login timeout setting for Microsoft Jet databases is 20 and is stored, depending on the version, in the following registry key:
HKEY_LOCAL_MACHINE\SOFTWAREMicrosoft\Jet\4.0\Engines\ODBC\LoginTimeoutYou can change this value from the default of 20; however, the new value will not be used in the OpenDatabase method of the current database, as in the following line:
Set db=OpenDatabase("",false,false,"odbc;DSN=TEST" )
If you have changed the registry key to something other than the default of 20, and you want to use that new value with the OpenDatabase method, you should include the DBEngine object, as in the following line:
set db=DBEngine.OpenDatabase("",false,false,"odbc;DSN=TEST" )
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall your operating system. Microsoft cannot
guarantee that problems resulting from the incorrect use of Registry Editor
can be solved. Use Registry Editor at your own risk.
For information about how to edit the registry, view the "Changing Keys and
Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete
Information in the Registry" and "Edit Registry Data" Help topics in
Regedt32.exe. Note that you should back up the registry before you edit it.
If you are running Windows NT, you should also update your Emergency
Repair Disk (ERD).
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4\Engines\ODBC\LoginTimeout
Set db=DBEngine.OpenDatabase("",false,false,"odbc;DSN=TEST" )
Set db=opendatabase("",false,false,"odbc;DSN=TEST" )
Additional query words: pra
Keywords : kbdta PgmObj
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug
Last Reviewed: May 13, 1999