Microsoft OLE DB Provider for Oracle error '80004005'

[jh]

I am receiving the following message when accessing the Oracle database:

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.

/index.asp, line 15

OS Platform is Windows 2000 Server SP4, PIII
Oracle Database is 9.0.1.

I can connect to the database through SQL*Plus and tnsping is successful.

Any help is appreciated.

Thanks in advance.

jh

[TurkBear]

Post by jh
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.
/index.asp, line 15
OS Platform is Windows 2000 Server SP4, PIII
Oracle Database is 9.0.1.
I can connect to the database through SQL*Plus and tnsping is successful.
Any help is appreciated.
Thanks in advance.
jh

Do you have your ORACLE_HOME properly set ( both in Registry and as a System Ennvironment Variable is best)?
Is your PATH set to correctly list the Oracle_Home/bin directory?
( If you have multiple Oracle Homes, you will need to set the default one correctly before trying the connection)

[Andy Hassall]

Post by jh
Microsoft OLE DB Provider for Oracle error '80004005'

Are you deliberately using the Microsoft driver instead of the Oracle driver?
The Microsoft driver is limited in various ways, since it's based on Oracle 7,
and does all sorts of bad things to the data that comes back.

Try changing the driver to the 'Oracle in OraHome90' driver (after setting the
environment and permissions as per the other posts).

--
Andy Hassall (***@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[jh]

Thanks for answering. it's working now. iis accts didn't have permission
to the oracle folder

jh

Post by Andy Hassall

Post by jh
Microsoft OLE DB Provider for Oracle error '80004005'

Are you deliberately using the Microsoft driver instead of the Oracle driver?
The Microsoft driver is limited in various ways, since it's based on Oracle 7,
and does all sorts of bad things to the data that comes back.
Try changing the driver to the 'Oracle in OraHome90' driver (after setting the
environment and permissions as per the other posts).
--
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[Niall Litchfield]

its a 'feature' of 9i installs on windows. Most accounts do not get *any*
permissions on $ORACLE_BASE. This is either a good thing or a bad thing.
--
Niall Litchfield
Oracle DBA
Audit Commission UK

Post by jh
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.
/index.asp, line 15
OS Platform is Windows 2000 Server SP4, PIII
Oracle Database is 9.0.1.
I can connect to the database through SQL*Plus and tnsping is successful.

In that case, the NT user under which IIS/ASP runs cannot.
Usually IIS is run in a guest account of sorts to minimize the damage
a hack attack can do (but then this seldom works givem Microsoft
flagrant disregard for security). Said guess account likely does not
have the ORACLE_HOME/bin it is path and cannot find the OCI and other
Oracle DLLs required.
--
Billy