Microsoft KB Archive/219022

= Improving Performance of MS-DOS Database Applications =

Article ID: 219022

Article Last Modified on 11/21/2003

-

APPLIES TO


 * Microsoft BackOffice Small Business Server 4.0
 * Microsoft BackOffice Small Business Server 4.5

-



This article was previously published under Q219022



IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
When you use older MS-DOS-based database applications with a Windows NT or Small Business Server (SBS) network, you may encounter various errors such as:

The file is in use

The file is already open

Unable to write to drive X:

The network drive X: is no longer available



RESOLUTION
These older MS-DOS-based database application engines were not developed with the file locking mechanisms that Windows NT enables by default. These settings are used to improve performance of Windows NT-aware applications, but can have different results with applications that do not understand them. The best solution is to upgrade the application to one that is compatible with Windows NT or SBS. If it is not possible to upgrade the application, there are changes in the registry that could improve the performance. These registry entries will turn off the use of opportunistic file locking and the caching of files previously open but now closed, and will prevent the networking portion from closing a workstation session that it thinks has timed out.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

Perform the following steps to disable opportunistic locking and caching of open files:  Start Registry Editor (Regedt32.exe) and go to the following subkey:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters

 On the Edit menu, click Add Value and add the following:

Value Name: EnableOplocks

Data Type: REG_DWORD

Data: 0

Value Name: CachedOpenLimit

Data Type: REG_DWORD

Data: 0

Value Name: autodisconnect

Data Type: REG_DWORD

Data: ffffffff

 Shut down and restart the computer.



MORE INFORMATION
For additional information about EnableOplocks, please see the following article(s) in the Microsoft Knowledge Base:

102967 REG: Server Service Entries, PART 1

For additional information about CachedOpenLimit, please see the following article(s) in the Microsoft Knowledge Base:

124916 Some Client Applications Fail When Writing to Windows NT

For additional information about Autodisconnect, please see the following article(s) in the Microsoft Knowledge Base:

138365 How the Autodisconnect Works in Windows NT

Additional query words: smallbiz

Keywords: kbprb KB219022

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.