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/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment