Hi!

I just upgraded my server to Windows 2003.
When I run my homepage on every page that uses ASP code in conjunction with SQL 200 SP3a I get the same error:

Error "8007007f'

The code is:
set ConnObj = Server.CreateObject("ADODB.Connection")
Set daten_RstObj = Server.CreateObject("ADODB.Recordset")
ConnObj.Mode = adModeReadWrite
conn_str="dsn=DSN_FV_WEB;uid=sa;pwd=kuguv"
connObj.Open conn_str
strSQL = "SELECT * FROM Headline_Aktuell WHERE Type <> 'f' ORDER BY Datum DESC;"
daten_RstObj.Open strSQL,ConnObj,adLockOptimistic
daten_RstObj.MoveFirst

The error message indicates that "connObj.Open conn_str" is the line where the error occurs...

Does anybody know what to do????

When I boot the server on windows 2000 everything works fine...


TNX
Gerhard

Has you DSN been defined in 2003? What is the text of the error message?

regards
David Cameron

Hi!

I installed Windows 2003 Server on the same partition (Dual Boot).
Then I installed MS SQL 2000 Server in a seperate directory (not to overwrite the existing SQL Server for Windows 2000) with SP3a and rebuilt every database and the DSN´s.

The error message is simply:
Fehler "8007007f'

/n_banner.asp, line 57


Greets
Gerhard

Have you installed the latest version of MDAC?

regards
David Cameron

MDAC 2.7 SP1 installed, same problem...

Greets
Gerhard

I'm out of ideas, sorry.

regards
David Cameron

Found on another forum :

http://www.microsoft.com/downloads/d...displaylang=en

This is the link to download the component checker.
HIH
dikkjo

hi, i got the same error but i'm workin' in MySQL i can't find any reason that would 'cause it to appear so plz help me ...
I tried already to install all kinds of the MDAC versions and tried to remove SQL Server already and still gettin' the same error, what should i do? My OS is Windows 2003 Server I have MYSQL & SQL Server
Serivce workin' together but tried to make them Stop and I removed them too so they won't work at all and still the same :(, PLZ HELP!

You can try to these steps:
1. Remove SQL Server files and registry keys manually. For more information,
please refer to the Microsoft knowledge Base article Q290991 'HOW TO:
Manually Remove SQL Srv. 2000 Default, Named or Virtual [sqlserver]'. The
web link of this article is:
http://support.microsoft.com/support.../q290/9/91.asp.
2. Try to install SQL Server 2000 again.
3. Then, you can get the latest version of MDAC under
http://www.microsoft.com/data.



Best regards,
Gregory Liénard

@iPower
Toekomstlaan 16i
B-2900 Schoten

Web: http://www.ipower.be

_______________________________________________
      MORE VISITORS WITH A PERMANENT
     TOPPOSITION AT THE SEARCH ENGINES

         http://www.Hit-Magnet.com
_______________________________________________

I had the same problem after upgrading to Windows 2003 Server. I called Microsoft and here is the fix:

Symptoms:
After upgrading from Windows 2000 to Windows 2003 attempting to access a database or data component will result in a '8007007f' or "The specified procedure 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: http://www.promiseweb.com/oledb32.zip

This is per Malcolm Stewart at Microsoft Developer Support