Active2 years, 6 months ago

One DataDirect ODBC driver supports all versions and platforms of DB2 while delivering performance and scalability. Download a free trial.

To install, follow the instructions below to download the driver, put it in the correct location, and set the appropriate permissions. Note: The Amazon Athena driver is a JDBC driver so it doesn't require an odbc.ini file.
If the kit and/or the iSeries odbc driver isn't the standard anymore for iSeries/DB2 connectivity from Windows (its been ahile since I've been in an i/db2 environment), please let me know what is--and where I can find it.
Download the driver you need by visiting the DB2 Fix Packs by Version page or the IBM Data Server Client Packages fix pack page, which contain links to all available Fix Packs The following command will retrieve the JCC driver version if executed from the command line.
I was successfully able to install the driver Downloaded from the above link but Instead of IBM DB2 ODBC Driver I am getting IBM DATA SERVER for ODBC. I want IBM DB2 ODBC Driver. How to go about it.

I need to connect to remote DB2 from local SQL Server 2008 R2. I don't want to use linked servers. So I am searching for download and trying to install IBM DB2 driver, as Microsoft ODBC driver for DB2 comes with Host Integration Server is expensive.

putvande

13.3k3 gold badges25 silver badges46 bronze badges

ChowChow

3 Answers

Ibm thinkpad t23 drivers xp. You can download DB2 clients for your DB2 version from here: http://www-01.ibm.com/support/docview.wss?uid=swg27007053

Client software is free.

mustacciomustaccio

15.1k8 gold badges41 silver badges44 bronze badges

The below link has a step by step guide that worked well for me

CidCid

1,1881 gold badge14 silver badges35 bronze badges

Ibm Db2 Odbc Driver Windows 7

Both answers are correct, but only have the links to were the answers are.

download the correct driver (called fix pack most of the time) you need from IBM
extract the contents of the zip file to c:program filesIBM , I unzipped it in c:program filesIBMclidriver
open a command prompt as administrator and change to the directory you just created and then go in the bin folder
execute the following commands to install and register the odbc drivers
check your odbc manager if the drivers are installed, this is depending on the version you selected (32 bit or 64 bit)

for the 32 bit version open your odbc data sources 32 bit otherwise open the odbc data sources 64 bit.

3 Compatibility may vary depending on user's hardware configuration and operating system. 5 Reformatting to HFS+ required for use with Time Machine ® software. Toshiba canvio installation software. 4 The preloaded NTI Backup Now EZ software is compatible with Windows ® OS only.

To open odbc data sources in windows versions 7 upwards

press the windows key
type odbc
click on the version you need (32 bit or 64 bit)

davejal

Db2 Driver For Windows 7

davejal

Ibm Db2 Odbc Driver 64-bit

4,5929 gold badges26 silver badges60 bronze badges

Download Ibm Db2 Odbc Driver

Not the answer you're looking for? Browse other questions tagged sql-serverdb2odbcdriver or ask your own question.