Install Db2 Driver On Windows

Posted on
Active2 years, 7 months ago

73 thoughts on ' How to install and configure DB2 ODBC driver ' 1. At the command prompt, it seems the command to install has changed. In Windows 10 or Windows 8, installation must be run from an Administrator Command Prompt. Scroll down and click on IBM DB2 ODBC DRIVER (or IBM DB2 ODBC DRIVER – DB2COPY1) Click Finish. You will then see a blank ‘ODBC IBM DB2 Driver – Add’ window. Enter SFMSP, as the ‘Data source name’ and click on “Add” and you should see the following window: Last updated: 12/12/11 Page 6 of 8. 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 files IBM, I unzipped it in c: program files IBM clidriver. Open a command prompt as administrator and change to the directory you just created and then go in the bin folder. Contains links to download DB2® 9.7 Fix Pack 1, servers, extenders, clients and drivers in Fix Central for AIX, HP-UX, Linux, Solaris, and Windows operating systems. The IBM Data Server Driver for JDBC and SQLJ package includes two JDBC drivers: The db2jcc.jar driver is now deprecated. After version 3.72, which is delivered with DB2 Version 11.1 for Linux, UNIX, and Windows Modification Pack 1 Fix Pack 1, db2jcc.jar will include no new features. However, fixes will continue to be delivered.

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.4k3 gold badges25 silver badges47 bronze badges
ChowChow

3 Answers

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.2k9 gold badges41 silver badges44 bronze badges

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

DriverDb2Cid

Install Db2 Driver On Windows 10

Cid
1,1881 gold badge14 silver badges35 bronze badges

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

  1. download the correct driver (called fix pack most of the time) you need from IBM
  2. extract the contents of the zip file to c:program filesIBM , I unzipped it in c:program filesIBMclidriver
  3. open a command prompt as administrator and change to the directory you just created and then go in the bin folder

  4. execute the following commands to install and register the odbc drivers

    Xbox one game save editor

  5. check your odbc manager if the drivers are installed, this is depending on the version you selected (32 bit or 64 bit)

Install Db2 Cli Driver Windows

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

To open odbc data sources in windows versions 7 upwards

  1. press the windows key
  2. type odbc
  3. click on the version you need (32 bit or 64 bit)
davejaldavejal
4,6229 gold badges26 silver badges60 bronze badges

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