Re: problems connecting to an oracle database

I think the IIS user id will need read/write permissions to the ORACLE_HOME and TEMP directories. You might also want to consider switching to the OLEDB provider from Oracle. I've had much better luck with it. In fact, I could never get the MS provider working at all.

Ray Porter

"Miguel Orrego" <miguel_at_stressedmonkey.net-nospam> wrote in message news:3e70b64b$0$241$cc9e4d1f_at_news.dial.pipex.com...
> Hi,
>
> I have just installed the oracle 8i client and configured a connection to
a
> database that I know works because when I tested it in net8 the tests were
> successful.
>
> However when I try to connect from an asp page I get the following error:
>
>
> Microsoft OLE DB Provider for Oracle error '80004005'
>
> The Oracle(tm) 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 greater) client software installation. You will be
unable
> to use this provider until these components have been installed.
>
> Here's the connection string:
>
>
> .ConnectionString = "Provider=MSDAORA;Data Source=ITSM;" & _
> "User ID=; Password=;"
>
> Has anyone seen this before? We didn't restart the web server after
> installing the oracle client software as I didn't think that was
necessary,
> as the server has shown it can connect successfully. Would it be necessary
> to give it a restart or can somebody help me pin this down to another
cause?
>
> Thanks in advance.
>
> Miguel.
>
>
Received on Thu Mar 13 2003 - 13:21:07 CST