SQL Serve database to DB2 connection server implementation (1)

This article will introduce you to the implementation of the SQL Server database to the DB2 connection server, and attach detailed examples and operation steps for your reference, I hope to help you.

In SQL SERVER, it is called LINKED SERVER, and ODBC is used to interconnect with other databases.

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 SQL SERVER, it is called LINKED SERVER, 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: SQLSERVER2000 (English version) and DB2 7.2 client (English version)

Specific steps:

1. Install the DB2 connection Server Client software and sqlserver2000 software on the PC.

2. 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 IBM DB2 odbc driver-> Custom Data Source Name (for example, DB2TEST)-> Database Name (required !) -"OK.

3. Select the name of the data source you Just configured, and then select Configuration to jump out of DB2 MESSAGES:

The data source is not connected. Connecting to the data source will provide useful information during configuration. wocould you like to connect to the data source?

Select YES (OK or OK ).