Solution to the 8007007f error when accessing the database after upgrading to 2003

datevalue (translation)

After upgrading from 2000 to 2003, when using asp to access the database, an 8007007f error always occurs in conn.open. Reinstalling IIS and SQL Server cannot solve the problem.
After investigation, it was found that this error does occur after upgrading some systems to 2003, and a solution was found:
Unzip oledb32.dll to the following two directories, and then restart the server 1) C:WINNTsystem32dllCache
2) C:Program FilesCommon FilesSystemOLE DB

download addressure could not be found" error.

Status:
This is a known issue with some installations of Windows 2003

Workaround:
Extract oledb32.dll from the zip file into these two directories. It's impo
rtant that it be done in this order:
1) C:WINNTsystem32dllCache
2) C:Program FilesCommon FilesSystemOLE DB
3) Reboot the server

Cause:
This issue is caused when the Windows 2003 installer did not update the oled
b32.dll file.

You can dowload the oledb32.dll file here: [url][/
url]

This is per Malcolm Stewart at Microsoft Developer Support