DB2 ODBC connection settings

Source: Internet
Author: User
Tags db2 db2 driver db2 odbc driver driver manager dsn ibm db2 ibm db2 driver odbc connection

Reference: http://www.withdata.com/blog/tips/how-to-install-and-configure-db2-odbc-driver.html

Drive:https://www-933.ibm.com/support/fixcentral/swg/selectfixes?parent=ibm%2finformation%2bmanagement& product=ibm/information+management/ibm+data+server+client+packages&release=10.5.*&platform=windows+32- Bit,+x86&function=fixid&fixids=*odbc_cli*&includesupersedes=0

How to Install and Configure DB2 ODBC Driver

by Shiji Pan

Posted on August

1 Download and Install

Download DB2 CLI ODBC Driver:

For x86 (32bit):

Https://delivery04.dhe.ibm.com/sdfdl/v2/sar/CM/IM/04qs9/0/Xa.2/ Xb.jusyltsp44s03o2gwpadmzldcfejnsfce8y8a4irgv6dueloadvnn04yxva/xc.cm/im/04qs9/0/v10.5fp4_nt32_odbc_cli.zip/xd. /xf.lpr.d1vk/xg.7844487/xi.habanero/xy.habanero/xz.jdm2cccvokn3ld3nwm-pj62vpea/v10.5fp4_nt32_odbc_cli.zip

https://www-933.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%2FInformation%2BManagement&product= Ibm/information+management/ibm+data+server+client+packages&release=10.5.*&platform=windows+32-bit,+x86 &function=fixid&fixids=*odbc_cli*&includesupersedes=0

For x64 (64bit):

Https://delivery04.dhe.ibm.com/sdfdl/v2/sar/CM/IM/04qs7/0/Xa.2/Xb.jusyLTSp44S03o2gwLvv_gehwZO_ fuekqsjmfo6rzhwdmk3fxwgsklzrkxq/xc.cm/im/04qs7/0/v10.5fp4_ntx64_odbc_cli.zip/xd./xf.lpr.d1vk/xg.7844482/ Xi.habanero/xy.habanero/xz.txv1zzgnxyn-0zygvq8qb8wk01k/v10.5fp4_ntx64_odbc_cli.zip

https://www-933.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%2FInformation%2BManagement&product= Ibm/information+management/ibm+data+server+client+packages&release=10.5.*&platform=windows+64-bit,+x86 &function=fixid&fixids=*odbc_cli*&includesupersedes=0

Uncompress the zip file to a folder, for Example:f:\work\clidriver.

In folder F:\work\clidriver\bin, right click on file Db2.ini--"Properties", uncheck the "Read Only" attribute.

Update: In recent version, you need create a "db2dsdriver.cfg" file in Path ' F:\work\clidriver\cfg ', content like This

<configuration>
<databases>
<database name= "Sample" host= "192.168.1.102″port=" 50000″>
<parameter name= "Currentschema" value= "Sample"/>
<wlb>
<parameter name= "ENABLEWLB" value= "true"/>
<parameter name= "Maxtransports" value= "50″/>
</wlb>
<acr>
<parameter name= "ENABLEACR" value= "true"/>
</acr>
</database>
</databases>
<parameters>
<parameter name= "Globalparam" value= "value"/>
</parameters>
</configuration>

2 Register ODBC Driver
Run "CMD", if Win7, run as Administrator (http://www.withdata.com/ad/tips/ how-to-open-elevated-command-prompt-with-administrators-rights-in-windows-7.html)

F:\work\clidriver\bin>db2oreg1.exe-i

Add "F:\work\clidriver\bin\" to your system PATH.

3 Create A new ODBC Data Source Name (DSN) using the ODBC Driver Manager.

The ODBC Driver Manager is in the Windows Control panel, Administrative Tools.

Add a "User DSN"

Select "IBM DB2 DRIVER for Odbc–f:/work/clidriver" as DRIVER.

Next, set "Data Source name"

In "Database alias" row, click "Add".

To ' Advanced Settings ' tab, click ' Add '.

Add "Hostname".

Add "Port", "Database", and "Protocol".

To "Data Source" tab, input "User ID" and "Password".

Click "OK".

4 Test DSN
Select Saved "DSN", click "Configure".

Click "Connect" to test.

Be sociable, share! Test connection is to ensure that both machines can ping through if different view whether the firewall is not shutting down

DB2 ODBC connection settings

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.