RE: Configure IIS connection?
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, mark.powell2@xxxxxx
- Date: Fri, 1 Oct 2010 10:06:04 -0700 (PDT)
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:
