RE: Configure IIS connection?

Mark is right on this one.  I went through the same thing and even had to 
install the ORAOLEDB.ORACLE driver with the 11g client from OTN, then 
carefully move the installation from the default 32bit to 64bit Program files 
directory to get Sql Server to see it to use for a bridge to an Oracle database.
It's a known issue, as the driver isn't registered in the default directories 
that were commonly used before Server 2008..

Kellyn Pedersen
Sr. Database Administrator
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen
www.dbakevlar.blogspot.com
 

--- On Fri, 10/1/10, Powell, Mark <mark.powell2@xxxxxx> wrote:


From: Powell, Mark <mark.powell2@xxxxxx>
Subject: RE: Configure IIS connection?
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Friday, October 1, 2010, 10:49 AM



I am nor sure but I am guessing that IIS wants the Oracle OLE drivers and on 
the last 9i cleint installation I did OLE is not installed as part of the 
default runtime.  You have to go back and do a custom install and check the 
Windows components to get the Oracle OLE driver.  With the 11g client I 
installed to use with SQL Server 2008 R2 I also had to do a non-default install 
to get the OLE pieces.
 
 



From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Dennis Williams
Sent: Thursday, September 30, 2010 2:30 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Configure IIS connection?



 
List,
 
A colleague is configuring MS IIS on a Win2008 server (64 bit). 
Installed Oracle 10.2.0.4 client and confirmed that the client can connect to 
the database.
 
IIS keeps giving the message "provider not found - may not be properly 
installed"
 
We have done this before on Win2003 server (32 bit) and the Oracle 9i client.
 
Any suggestions appreciated,
 
Dennis Williams


      

Other related posts: