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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Linked Server in SQL 2008

818883Nov 26 2010 — edited Dec 29 2010
Hi,

Do I only have to install the Oracle 11g Release 2 ODAC 11.2.0.1.2 software to establish a connection beetwen SQL and Oracle?
Do I need to restart the SQL service as well?

I do not have the "OraOLEDB.Oracle" Provider in my SQL linked server list though i have installed the ODAC components (including Instant client)

I am just starting with Oracle so sorry for this basic questions. If anybody knows something please let me know!!
Doese anyone have a documentation for configurung SQL Server for that?

Thank you very much, Daniel

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 26 2011
Added on Nov 26 2010
3 comments
219 views