(reprint) IBM DB2 Database ODBC configuration steps detailed

Source: Internet
Author: User
Tags db2 db2 odbc driver dsn ibm db2 ibm db2 database ibm db2 odbc driver odbc

"IT168 Technology" first installs IBM DB2 ODBC driver

1): DB2 run-time Client can be downloaded separately, approximately (86.6m), after installation The ODBC driver is installed successfully. : ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2winIA32v8/fixpak/FP17a_WR21440/FP17a_WR21440_ RTCL.exe

2): The IBM DB2 database can also be installed directly after the driver is installed automatically. Database Http://www6.software.ibm.com/sdfdl/v2/regs2/db2pmopn/Express-C/DB2ExpressC9/Xa.2/Xb.AjZr_ 0m973fvbnzx63ecwwrnyaoisx2bvox3ehc/xc.db2exc_952_win_x86.zip/xd./xf.lpr.d1vk/xg.4854742/ Xi.swg-db2expresscviper2/xy.regsrvs/xz. C7tz8b_fn0_ruc3stdvpbwy2qpi/db2exc_952_win_x86.zip

The following shows how to create a DSN and connect to the DB2 database. DB2 database information is as follows:

ip:, Port: 50000

User name: admin

Password: admin

Database name: db2test

Set DSN to: Outbound


1.1 Open ODBC Data Source Administrator

1.2 Creating a data source

1.3 Adding a data source name

1.4 ODBC settings

1.4.1 User name and password

1.4.2 Enter host name and port

1.1 Open ODBC Data Source Administrator

Click the Add button to go to the Create Data source page. :

1.2 Creating a data source

Select "IDB DB2 ODBC Driver" click "Finish" to go to the data Source name Settings page.

1.3 Adding a data source name

Add a data source name, such as outbound,

Select a database alias in the drop-down box.

If not, click "Add" to go directly to the 1.3ODBC settings.-"The text below can be skipped.

If so, click OK directly to return to the ODBC Data Source Administrator page.

Double click the "Configure" button, enter the user name and password, tick save password, test the connection is successful, that is done.

1.4 ODBC settings

For example, we want to connect to on the database db2test, the database user name and password for the admin, you need the following configuration,

1.4.1 User name and password

Enter the user name and password to connect to the other database, such as admin and admin.

1.4.2 Enter host name and port

Enter the host IP, which is

Port, which is 50000

Database name, which is Db2test

Alias: You can just pick up a drop-down box and not repeat the name.

Click OK to return to the following.

Select the outbound data source name, open the Configure button, click Test, and the Connect Success dialog box appears. The configuration is complete.

Original link: http://xujingli88.blog.163.com/blog/static/411786192009324294164/

(reprint) IBM DB2 Database ODBC configuration steps detailed

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.