升级到2003后访问数据库发生8007007f错误的解决

答案：2000升级到2003后使用asp访问数据库时，在conn.open始终发生8007007f错误
重装IIS和SQL Server均得不到解决。
经查，发现部分系统升级到2003后的确会发生此错误，并且找到了解决的办法：
将 oledb32.dll 解压到一下两个目录，然后冲重启服务器1) C:\WINNT\system32\dllCache
2) C:\Program Files\Common Files\System\OLE DB

下载地址 http://www.promiseweb.com/oledb32.zip


 
一下是原文
I had the same problem after upgrading to Windows 2003 Server.  I called Mic
rosoft and here is the fix:

Symptoms:
After upgrading from Windows 2000 to Windows 2003 attempting to access a dat
abase or data component will result in a '8007007f' or "The specified proced
ure 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:\WINNT\system32\dllCache
2) C:\Program Files\Common Files\System\OLE 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]http://www.promiseweb.com/oledb32.zip[/
url]
 
This is per Malcolm Stewart at Microsoft Developer Support

上一个：Access转SqlServer的语法注意事项
下一个：SQL自定义函数的应用