Re: Microsoft OLE DB Provider for Oracle error '80004005'

"jh" <jhui_at_rcn.com> wrote in

> 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