Showing posts with label 8007007f. Show all posts
Showing posts with label 8007007f. Show all posts

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