I need to connect to an Oracle 8g server from SQL Server 2008 R2 64 bit.
I installed [Oracle Data Access Components (ODAC) 220.127.116.11.1|http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html ], then installed the 8g client tools.
I can confirm 8g client tools can connect to the database by itself, but I am unable to create a linked server in sql server. I am not sure what dll (8g or 11g) it is using to connect. I receive the following area when I hit create linked server:
Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLEDBDEV" . (Microsoft SQL Server, Error: 7302)
Where can I set which DLL it uses? Should I be using the dll for 8 or 11?