Basically, you have to install the Oracle client software on your SQL server, then using references in the tnsnames.ora file, you create the linked server using the "Oracle Provider for Ole DB" driver.
Reference:
http://gleew.wordpress.com/2008/03/19/sql-server-linked-server-to-oracle/
Wednesday, April 25, 2012
Subscribe to:
Posts (Atom)