How to install the DB2 ODBC or OLEDB driver

Question

I have already installed IBM DB2 Database Express on Windows 7 Pro.

Now I would like to create my C # code to select / insert / update records in DB2 tables.

I spend all day searching the Internet for links on how to install an OLEDB or ODBC driver to connect to a DB2 database. But without success !!!

So, I am wondering if anyone can help me or send me a useful link to download the driver.

thanks

+4

Paul Feb 25 '13 at 18:50

4 answers

Sathy sannasi · Answer 1 · 2013-02-26T11:17:47+0000

For DB2 9.7, check here:

Download

IBM Data Server Driver for ODBC and CLI (64-bit) (or) IBM Data Server Runtime Client

Hth

Sathyaram

Joaquinglezsantos · Answer 2 · 2015-12-17T15:43:35+0000

Download

With options for "Information Management" - "IBM Data Server Client Data Packages" - Custom Version and Platform

Then write * odbc_cli * in Id Fix

Download the latest fix pack (in my case, "IBM Data Server Driver for ODBC and CLI (Windows / x86-64 bit) V10.5 Fix Pack 7")

Installation:

Copy the zip to C: \ Program Files \ IBM (if it does not exist, you must create a folder) Extract it

In cmd:

Run "cd C: \ Program Files \ IBM \ {folder with an uncompressed driver} \ bin" (default is "clidriver")

Install "db2cli install -setup" to install. If you need to remove, run the command "db2cli install -cleanup"

If you need to install it to point to the IBM DB2 ODBC 32-bit driver for a 32-bit application in a 64-bit environment, read this documentation: http://www-01.ibm.com/support/docview.wss?rs= 71 & uid = swg21384435

Note: in version 9.5. * the command changes: Install: db2oreg1.exe -i Delete: db2oreg1.exe -u

In my opinion, I recommend downloading the IBM Client I Access with a custom installation, selecting only "ODBC" and "OLE DB Provider"

You can download it via ibm public ftp: public.dhe.ibm.com (port 21) in the folder "/ as400 / products / clientaccess / win32 / v7r1m0 / servicepack"

Cid · Answer 3 · 2016-06-16T08:16:25+0000

Bernhard · Answer 4 · 2017-07-20T09:06:59+0000

There is also a microsoft version of the db2 driver (part of the host integration server).

In each sql server function package you will find DB2OLEDBV [version] _ [architecture] .msi

eg. sql2016sp1 has v6 (ENU \ DB2OLEDBV6_x64.msi and ENU \ DB2OLEDBV6_x86.msi) https://www.microsoft.com/en-us/download/details.aspx?id=54279

Information: