none
Problems with a linked server from a SQL Server 2008 R2 to Oracle 11.2g

    Question

  • Hi,
    I've 64-bit SQL Server 2008 R2 (SP1) on 64-bit Windows Server 2008 R2 (SP1) and Oracle 11.2g. I installed the Runtime option of 64-bit Oracle 11g Client Release 2, edited %ORACLE_HOME%\Network\Admin\TNSNAMES.ora and restarted the SQL Server instance and Windows server.

    When I created a linked server and tested the connection, I got "The OLE DB provider 'OraOLEDB.Oracle' has not been registered. (Microsoft SQL Server, Error: 7403)". I ran regsvr32 OraOLEDB11.dll and restarted the Windows server but got the same error. The PATH includes %ORACLE_HOME%\bin directory. The 'Authenticated Users' have read & execute permissions to %ORACLE_HOME% directory and its subdirectories and files. Any idea how to fix this?

    Thursday, April 12, 2012 2:56 PM

Answers

All replies