This article takes SQL Server 2k as an example to illustrate the specific implementation process for SQL Server to Oracle connection server.
1. Requires the Oralce client software and sqlserver2000 software to be installed on the PC.
2. Client configuration Tnsnames.ora file, configure the database server to connect to (Windows,unix and other platforms can be)
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 for Windows:
Start Menu-"Settings-" Administrative Tools-"data source (ODBC)-" Enter the configuration User DSN or System DSN can: Add-"Select Microsoft ODBC for oracle-" Custom data source name (preferably with the same name as the connection string in TNS!) )-"Server name (required!) Fill in the name of the connection string in the TNS file)-"complete.
4. Configure the connection server in the sqlserver2000:
Enterprise Manager-"Security-" Connect Server-"Right-click New Connection Server-" define the connection name; select another data source; Specify the program name: Microsoft OLE DB Provider for Oracle; The product name is optional; The data source specifies the data source name that was defined in ODBC just now; The provider string is populated in the following format: User id=username; PASSWORD=USERPASSWD (or by the following format: Uid=username; PWD=USERPASSWD), where the username and password correspond to the user name and password in the Oracle database to which you want to connect-the Security tab: Set up in this security context and enter Oracle's database username and password-The Server Options tab can be determined by default-"."
5. All preparations are complete! In SQL Server Enterprise Manager-"security-" connect the server to open the newly built connection server-click on the table, you can see the Oracle database user in the right window all the table names, but here is not able to view the table records, This needs to be implemented in the Sqserver Query Analyzer with specific SQL! When accessing a table, use the format: [Connect server name] ... [Oracle user]. [Table name]. More detailed specific use here no longer repeat.
http://www.bkjia.com/PHPjc/631124.html www.bkjia.com true http://www.bkjia.com/PHPjc/631124.html techarticle This article takes SQL Server 2k as an example to illustrate the specific implementation process for SQL Server to Oracle connection server. 1. Requires the Oralce client software and sqlserver2000 software to be installed on the PC. 2. Configuration of the client ...