Skip to Main Content

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!

Linked server to Oracle 11g from MSSQL

xUrkoMar 25 2015 — edited Mar 26 2015

I have installed Oracle 12g 32-bit client as Administrator type, set up Service Name configuration with Network Configuration Assistant and successfully tested connection with SQL *Plus to Oracle database. Than I wanted to create a linked server to Oracle database in MSSQL 2012 and found out that Oracle Provider for OLE DB is not listed. Do I need to manually register the oracle provider or do I need also need to install Oracle Data Access Components (ODAC)?

BR, Uroš

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2015
Added on Mar 25 2015
3 comments
12,193 views