How do you setup a linked server to an Oracle database on SQL

Posted by imomins on July 26, 2011 at 8:05 AM Comments comments (0)

setup a linked server to a remote Oracle database, which ended up being a multi-step process:

Install Oracle ODBC drivers on SQL Server.

Create System DSN to Oracle database on SQL Server.

Create linked server on SQL server using System DSN.

Step 1: Install Oracle ODBC drivers on server

a. Download the necessary Oracle Instant Client packages: Basic,...

Read Full Post »