ODBC DLLs Can Be Overwritten on Windows 2000

• Microsoft Windows 2000 Server
• Microsoft SQL Server version 7.0
• Microsoft Windows 2000 Advanced Server
• Microsoft Windows 2000 Datacenter Server

SYMPTOMS

If you install programs that install an older version of ODBC on your computer running Windows 2000, the computer may not respond as expected. For example, Terminal Services, which relies on ODBC, does not function correctly if an older program (one that predates Windows 2000) installs ODBC components.

In this case, Terminal Services prevents users from authenticating properly if ODBC versions do not match. You may experience different symptoms on your computer depending on your configuration.

CAUSE

This behavior occurs because ODBC DLLs are not protected system files. As a result, programs such as Microsoft SQL Server can overwrite DLL files that already exist in Windows 2000.

RESOLUTION

To resolve this behavior:

1. Copy the newer version of the ODBC files back into the %SystemRoot%\System32 folder, thus replacing any older versions.



2. Restart the server.

STATUS

Microsoft has confirmed that this behavior occurs by design.

MORE INFORMATION

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

Q222193 Description of the Windows 2000 Windows File Protection Feature

Q222471 Description of the Windows 2000 System File Checker Tool

Additional query words:

Keywords :
Version : WINDOWS:2000; winnt:7.0
Platform : WINDOWS winnt
Issue type : kbprb