The SQL Server 2000 takes an example of the specific implementation process of SQL Server to Oracle Connecting Server.
1. Requires the installation of Oralce client software and SQLServer2000 software on the PC.
2. The client's configuration TNSNAMES.ORA file, configure the database server (Windows, UNIX and other platforms) to be connected)
EG: TNSNames.ora
......
Test =
(Description =
(Address_list =
(Address = (protocol = tcp) (Host = 10.1.11.90) (port = 1521)))
)
(Connect_data =
(SID = Blue)
(Server = DEDICATED)
)
)
......
3. Configure the ODBC data source of Windows:
Start menu - "Setting -" Administrative Tools - Data Source (ODBC) - "Enter Configuring User DSN or System DSN can: Add -" Select Microsoft Odbc for Oracle- "Custom Data Source Name (Best to connect to TNS Squares with name!) - "Server Name (required! Fill in the connection string name in the TNS file) -" Complete.
4. Configure the connection server in SQLServer2000:
Enterprise Manager - "Safety -" Connection Server - "Right click New Connection Server -" Defines the Connection Name; Select another data source; specify the program name: Microsoft Ole DB Provider for Oracle; product name can be not filled; Data Source Specify ODBC Deconsive data source name; Provider string fill in in the following format: user id = username; password = userpasswd (or press Uid = UserName; PWD = UserPasswd), the username and password here correspond to Oracle to be connected Username and password in the database - "Security tab: Settings with this security context and enters Oracle's database username and password -" Server Options Tab Default - "OK.
5. Preparations are all completed! In SQL Server Enterprise Manager - "Security -" Connection Server Opens the Junited Connection Server - "Click on the table, you can see all the table names owned by the Oracle database user in the right window, but you can't view it here. Record of the table, this need to be implemented in specific SQL in the query analyzer of SQ Server! When accessing the table, the format is: [Connect Server Name] .. [Oracle User]. [Type]. More detailed use is not described here.
