SQLServer2008 new linked server for Oracle
A view of Oracle 10g has recently been used in SQLServer2008 to make use of Oracle-provided views in SQL Server by establishing linked servers. Premise: SQL Server requires client installation of Oracle 1. Configuring Oracle Connection information Configure the Oracle database to be connected in the Tnsnames.ora file rdora101_10.23.116.15 = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.23.116.15) (PORT = 1521))) (Connect_data = (service_name = RDORA101))) 2. server Objects---> Linked servers in SQL Server---> new linked Servers, as shown in:
The name of the linked server can be arbitrary, and the data source is the rdora101_10.23.116.15 configured in the Tnsnames.ora file. 3. In the Security Selection page, enter the user name and password to connect to Oracle as shown in:
4. Click OK to create a good linked server. 5. Use the linked server (where test is the name of the linked server created) Select ID, name, Compid, JGDM, status from OPENQUERY (Test, ' select * from Ibams.ams_cm_v_ca Rdinfo ');
SQLServer2008 new linked server for Oracle