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