Implementation of Oracle SQL Server to connect to the server: Jennifer In this paper, SQL Server 2k as an example SQL Server to Oracle implementation process connection to the 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 to be connected (Windows, UNIX and other platforms) EG: TNSNAMES. ORA ... TEST = (deSCription = (address = (protocol = TCP) (host = 10.1.11.90))))))) (connection_data = (SID = blue)) ... 3. Configure the ODBC data source of Windows: Start menu - " Setting - Administrative Tools - Data Source (ODBC) - "Enter the Configuring User DSN or System DSN can: Add -" Select Microsoft Odbc for Oracle- "Custom Data Source Name (It is best to connect the string in TNS!) - "Server name (required! Fill in the connection string name in the TNS file) -" Complete. 4. Configure the Connection Server in SQLServer2000: Enterprise Manager - "Security -" Connection Server - "Right click New Connection Server -" Defines the Name of the Connection; Select another data source; specify the program name: Microsoft Ole DB Provider for Oracle; product Names can be filled; data source specifies the data source name that is just defined in ODBC; providing program string filled in: user id = username; password = userpasswd (or press Uid = UserName; PWD = Userpasswd), here The username and password correspond to the username and password in the Oracle database you want to connect - "In this security context: Set this security context, and enter the Oracle database username and password -" Server Options Tab can be default-"OK. 5. Preparations are all completed! In SQLServer Enterprise Manager - "Security -" Connection Server Opens the Junited Connection Server - "Click on the table, you can see all the table names owned by the ORAC Le database user, but not here View the record of the table, this need to be implemented with specific SQL in the query analyzer of SQServer! When accessing the table, the format is: [Connect Server Name] .. [Oracle User]. [Type]. More detailed use is not described here.
