Error Message: Microsoft OLE DB Provider for ODBC Drivers Error '80004005' (238971)

We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:

http://www.microsoft.com/technet/security/prodtech/IIS.mspx

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 an Internet Information Server (IIS) ASP page to access a database, the connection may fail with the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

CAUSE

If you have used the C2 security program from the Windows NT Resource Kit on your system, the following registry key may only have read permissions assigned to the Everyone group:

Hkey_Local_Machine\Software\ODBC

In order for the ODBC drivers to function properly, the Web user accounts must have full control of this registry key.

RESOLUTION

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.
To assign full-control permissions to the Everyone group, follow these steps:

Start Registry Editor (Regedt32.exe).
Locate the following key in the registry:
Hkey_Local_Machine\Software\ODBC
On the Security menu, select Permissions.
Select Replace Permission on Existing Subkeys and set the permissions for the Everyone group to full control.
Quit Registry Editor.

MORE INFORMATION

For additional information on the C2 security update utility, consult the Windows NT Resource Kit, or see the following articles in the Microsoft Knowledge Base:

185874 How to Troubleshoot Permissions in IIS 4.0

137018 Availability of C2 Security Compliant Windows NT

93362 C2 Evaluation and Certification for Windows NT