How to connect a server from Sybase to Oracle

How to connect a server from Sybase to Oracle

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" to configure the user DSN or system DSN: 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 in the menu.

Select NEW button to display 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 data source name and select the ODBC

ORACLETEST. 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.

I will try again later!