1: SQL Server Connect Oracle1. Configure Windows ODBC Data Source: Start Menu - "Setting -" Administrative Tools - "Data Source (ODBC) -" Enter User DSN or System DSN can: Add - "Select Microsoft Odbc for Oracle- "Custom Data Source Name (best to connect to the same name in TNS!) -" Server Name (required! Fill in the TNS file in the TNS file) - "Complete.
2. Configure the connection server in SQLServer2000: Enterprise Manager - "Security -" Connection Server - "Right click New Connection Server -" Define Connection Name; 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.
