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!

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

930625Apr 17 2012 — edited Apr 18 2012

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?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2012

Added on Apr 17 2012

#11g, #client, #error, #oracle-provider-for-ole-db, #windows-and-net

1 comment

9,046 views