1 Reply Latest reply on Jul 5, 2011 7:14 PM by gdarling - oracle

    SQL Server 2008R2 64bit to Oracle 8g issue


      I need to connect to an Oracle 8g server from SQL Server 2008 R2 64 bit.

      I installed [Oracle Data Access Components (ODAC)|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?

      Any help would be much appreciated.