problems connecting to an oracle database

From: Miguel Orrego <miguel_at_stressedmonkey.net-nospam>
Date: Thu, 13 Mar 2003 16:48:07 -0000
Message-ID: <3e70b64b$0$241$cc9e4d1f@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 - 10:48:07 CST