Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!phobos.visi.com!news-out.visi.com!hermes.visi.com!news.state.mn.us!not-for-mail From: TurkBear Newsgroups: comp.databases.oracle.server Subject: Re: HELP: Connecting IIS to an Oracle Database Date: Thu, 12 Dec 2002 08:53:21 -0600 Organization: Minnesota Governmental/Educational Agencies Lines: 30 Message-ID: <4c8hvu0mkot1iqj4j7o149mu1q1u03u69a@4ax.com> References: <3e281b32.0206120411.445707fc@posting.google.com> <2269640.1039640597@dbforums.com> <27dfvuo9jto5fql7ib00a776veu9j1bhg4@4ax.com> <2270277.1039647329@dbforums.com> Reply-To: johng@mm.nospam.com NNTP-Posting-Host: gateway.dot.state.mn.us Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.state.mn.us 1039704803 8617 156.98.4.11 (12 Dec 2002 14:53:23 GMT) X-Complaints-To: news@news.state.mn.us NNTP-Posting-Date: Thu, 12 Dec 2002 14:53:23 +0000 (UTC) X-Newsreader: Forte Agent 1.8/32.548 Xref: newsfeed1.easynews.com comp.databases.oracle.server:169514 X-Received-Date: Thu, 12 Dec 2002 07:52:58 MST (news.easynews.com) 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 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