Environment:mssql:2008ORACLE db:10.2.0.1no previous contact with MSSQL, recently due to the need for MSSQL access to the table in Oracle, the following is the configuration of the MSSQL connection Oracle.1. Install the Oracle client on the MSSQL machine and configure TNS to connect to Oralce, here my configuration is as follows:Oracl_10ga = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.101) (PORT = 1521) )) (Connect_data = (service_name = oracl) ))once configured, you can use tnsping to check if the connection is successful.C:\Documents and settings\administrator>tnsping oracl_10gaTNS Ping Utility for 32-bit windows:version 10.2.0.1.0-production on 1 April-October -2012:Copyright (c) 1997, 2005, Oracle. All rights reserved.used parameter file: D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.oraused the TNSNames adapter to resolve aliasesattempting to contact (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = Ce_name = Oracl)) Ok (10 ms) /c5> 2. Enter Micosoft SQL Server Management Studio to select a connection server 3. Click New Connection ServerConnection server: link_oracle//This name can be arbitraryprovider selection: Microsoft OLE DB Provider for OracleProduct Name: Oracledata Source: Oracl_10ga//Here is the configuration of TNS4. Configuration of security optionsRemote connection: hxl_test//This is the user who accesses the Oracle databaseUse password: password for the database5. Accessing tables under the Oracle databaseSELECT * from OPENQUERY (link_oracle, ' SELECT * from Tb_hxl_test ')--The End- -http://blog.chinaunix.net/uid-77311-id-3372495.html
How MSSQL accesses tables in Oracle
