Linked Server in SQL 2008
818883Nov 26 2010 — edited Dec 29 2010Hi,
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