Re: HELP: Connecting IIS to an Oracle Database

Try this and see if it connects
substitute Provider=MSDAORA.1 for your Provider statement ( if it does not work, you do not have the Oracle OLE DB stuff installed ( they are not the same as the ODBC stuff)) Run the installer again and do a custom install and add ( usually found under the Programming section) the OLE DB provider  

tom_nichols <member_at_dbforums.com> wrote:

>
>hth,
>
>ORACLE_HOME LOOKS GOOD in the registry
>ORACLE_HOME/bin is in the path path
>
>I think I am trying to use the Oracle OLE DB provider.
>
>When I did the install of the Oracle Client, selected the Admin which
>installs everything. 581 MB of stuff... and it was sucessful... I
>rebooted after the installation. I created the ODBC drivers and did the
>test connections and that worked.. Then I tested my application that
>uses the OLE DB interface and I get the error message...
>
>Do you have to do something different or extra to have the OLE DB stuff
>installed.... ?
>
>Tom
Received on Thu Dec 12 2002 - 08:53:21 CST