(reprint) IBM DB2 Database ODBC configuration steps detailed

"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:192.168.1.46, Port: 50000

User name: admin

Password: admin

Database name: db2test

Set DSN to: Outbound

Steps:

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 192.168.1.46 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 192.168.1.46

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