Thursday, March 22, 2012

Error '8007007f' after upgrading to Windows Server 2003

After upgrading to Windows Server 2003, i receive Error '8007007f' when quer
ying the database, it says i have an error on this line. I am running SQL Se
rver 2000 with SP 3a
Specter.Open "Provider=SQLOLEDB;User ID=;Password=;Data Source=Excursion;Dat
aBase=AE;Integrated Security=SSPI"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

No comments:

Post a Comment