I have an issue connecting using ASP to Oracle 9.2 on windows 2000. Client 
is 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 
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. 

Connect string is:
Provider=MSDAORA.1;Password=xxxxxx;User ID=xxxxx;Data Source=xxxx;Persist 
Security Info=True

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

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

Fairly generic messages. Obviously the client is there and networking 
components. I have been able to connect using other tools such as 
ColdFusion on the same server. ODBC works independently. I have ensured 
that MDAC2.7 is installed.

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