OraOLEDB not appearing as an option in the 'Providers' list SQL Server 2008
271736Nov 10 2010 — edited Nov 15 2010Hi 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...