SQLSERVER2008R2 Link Server to Oracle 11g

• First, my SQL Server R2 and oracle11g are installed on the same computer.

Let's take a look at the configuration method:

1. After configuring the ODBC installation to complete Oracle in the driver, there will be Oracle in ORADB11G_HOME1 this driver such as:

Then add the data source configuration in the user DSN as follows:

and then save.

2. Open the provider in SQL Server, then double-click Open Oracledb.oracle, tick the dynamic parameters and allow the process, and then save. Such as:

3. Create a new linked server, such as:

Double-click Open new Linked server, point general, configured as follows:

Note that the data source here should fill in the configuration of the instance in the Oracle configuration file Tnsnames.ora (to write a line of several lines in the box), such as:

Click again to open the security configuration below:

Then save it, and you can.

I am also the first time configuration here for easy reference. There must be other ways, hope Bo friends teach me.

Cross-Link query statements:

SELECT * FROM OPENQUERY (link name, ' SELECT column_name from table_name ')

SQLSERVER2008R2 Link Server to Oracle 11g