Hi,

We´re running on the same problem here.
W2K + MDAC 2.7 SP1 + Oracle 9.2

Did you find an answer ?

Thanks in advance,
Giancarlo

> I have an issue connecting using ASP to Oracle 9.2 on windows 2000. 
Client 
i> s installed and database is on the same server.

> Error is:

> Microsoft OLE DB Provider for Oracle error '80004005' 

> Oracle client and networking components were not found. These components 
a> re supplied by Oracle Corporation and are part of the Oracle Version 
7> .3.3 or later client software installation. Provider is unable to 
f> unction until these components are installed. 

> Connect string is:
P> rovider=MSDAORA.1;Password=xxxxxx;User ID=xxxxx;Data 
Source=xxxx;Persist 
S> ecurity Info=True

> which I got from UDL. When I try the same using ODBC (MSDASQL), I get:
M> icrosoft OLE DB Provider for ODBC Drivers error '80004005' 

> Specified driver could not be loaded due to system error 5 (Oracle in 
O> raHome92). 
 > 

> Fairly generic messages. Obviously the client is there and networking 
c> omponents. I have been able to connect using other tools such as 
C> oldFusion on the same server. ODBC works independently. I have ensured 
t> hat MDAC2.7 is installed.

> I'm all out of ideas I'm afraid. Can anyone help?