Microsoft OLE DB Provider for Oracle error '80004005'

[teqmem]

Hello,

I currently run an ASP application on Windows 2000 Server with IIS 5.0 and Oracle 8.1.7 Client. It has been running for years.

I need to move the application to another server which is running Windows 2003 Server. I installed Oracle 8.1.7 and I can SQLPlus to the Oracle server, however, when I connect to the ASP application, I get the following error from this line:

dbConn.Open("Provider=MSDAORA;Data Source=xxx;User Id=yyy;Password=zzz;")

Microsoft OLE DB Provider for Oracle error '80004005' 

Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.

How do I work around this problem?

Thanks.

 

[mrdenny]

Check the MSKB. There is some info in there about how to tell MSDAORA that the Oracle software is installed. This is usually caused by the Oracle installer not registerng some reg keys.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com