Implementation of connecting Sybase to the Oracle server

The interconnection of different database platforms is generally called the heterogeneous service of databases. Currently, all major databases can achieve such Heterogeneous Interconnection, but the specific implementation technologies of different vendors are different, such: in SYBASE, it is called connect or connection profile, and ODBC is used to interconnect with other databases.

The test environment in this article is:

Operating System: WINDOWS2000 SERVER (Traditional Chinese system ).

Install the database: SYBASE8.0 SERVER (English version) and ORACLE92 client (English version ).

Specific steps:

1. Install the ORACLE client software and SYBASE8.0 SERVER software on the PC.

2. First, ORACLE should establish the service name.

For example:

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora# Generated by Oracle configuration tools.……TEST= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =10.100.1.101)(PORT = 1521)) ) (CONNECT_DATA = (SID = test) ) )……

3. Configure the ODBC data source for windows:

Choose "start"> "program set"> "System Management Tools"> "Data Source ODBC"> "Enter the user DSN or system DSN Configuration: add-select ORACLE ORA92HOME-> Custom Data Source NAME, for example, ORACLETEST)-> tns service name (required !) Enter the ORACLE Database user id in the TEST-> user id above-and click OK.

ODBC configuration and test completed!

4. Configure the connection SERVER in SYBASE8.0 SERVER:

Start sybase central.

Select the connection profiles option in TOOLS.

Select NEW button to display the new profile, enter your connection name in NAME, select copy profile, select adaptive server ANYWHERE8.0 in connection profile, and click OK. The EDIT CONNECTION PROFILE screen is displayed.

USER: Enter the USER Name of the ORACLE database.

PASSWORD: enter the PASSWORD of the ORACLE database user.

Next, select odbc oracletest from the oracle data source name field and select OK!

When accessing a table, the format is [connection server name]... [ORACLE user]. [Table name].

For more details, I will not go into details here.

(