SQL Server connection server access DB2 settings steps Diagram

Source: Internet
Author: User
Tags how to use sql server how to use sql

Original http://database.51cto.com/art/201108/283240.htm

SQL ServerAvailableLinked serverFunction to connect to other databases to perform operations between different databases. This topic describes how to use SQL Server to connect to a server.DB2The operation steps of the database are given in detail. Let's take a look at this part.

Use the link server of SQL Server to connect to DB2

1. Download and install Microsoft oledb provider for DB2. The default access interface on the SQL server connection server does not have DB2.

2. OpenProgramMenu-Microsoft oledb provider for DB2-data access tool.

3. Use the data access tool to create a data source.

On the platform, I chose DB2/as400 (the server is an HP minicomputer). The shared name of the next certificate is omitted.

I wrote the database name for the initial directory and package set. The default Delimiter is blank.

4. Obtain the connection string

5. create an SQL server linked server, link the server (named by yourself), select Microsoft OLE DB provider for DB2 as the access interface, and set the product name (available database name) to the server name as the data source, the access interface string is the connection string generated in the preceding tool.

6. After the connection test is successful, you can query it, for example:

    1. Select *
    2. From [db2svr]. [DB2]. [administrator]. [ABC]

The above is the whole process of using the SQL Server link server to connect to DB2 for operations. This article introduces so much and hopes this introduction will help you.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.