Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OraOLEDB not appearing as an option in the 'Providers' list SQL Server 2008

271736Nov 10 2010 — edited Nov 15 2010
Hi there,

I'm trying to create a linked server to an Oracle 10g database from SQL Server 2008 R2, but the required OraOLEDB.oracle driver is not appearing in the list of providers. We are trying to recreate our prod environment where we use the 11g client to connect to the 10g db, so I downloaded the installed the 11gClient ODADC (11.1.0.7). I have the Oracle folder in my 'Start' menu (Windows 2008 O/S), and it looks like the Oracle install was successful but in the registry (regedit) I don't see Oracle listed as 'software' in the local_machine/software listing.

I set my Oracle home to C:\Oracle and the path under there is
product\11.1.0\client_1

I've also read in some other posts that I should have both a 32 bit and 64 bit Oracle driver installed - I'm assuming that 11g is 64-bit and 9i is 32 bit?

Should I be able to install just the client or do I need to install the Server as well?

Any suggestions?

Thanks in advance for...

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 13 2010
Added on Nov 10 2010
1 comment
282 views