Do not mix 32/64 bit DB2 client and FME applications; There used to be issues with connecting to 'iSeries Access ODBC Driver' clients. This has been fixed in newer versions of FME. Useful Links: IBM Support: DB2 ODBC CLI driver Download and Installation information; IBM Fix Central downloads - see image below. Dec 12, 2011 Tools, and Data Sources (ODBC). Windows 7 (64 bit) users: 1. Windows 7 Control Panel brings up the 64-bit ODBC Data Source Administrator; you must. Scroll down and click on IBM DB2 ODBC DRIVER (or IBM DB2 ODBC DRIVER – DB2COPY1) Click Finish. Instructions for downloading and installing the latest version of the IBM DB2 Data Server. To access DB2/400 data on an iSeries system with an ODBC Driver, you must install the appropriate iSeries Access for Windows client on the 32-bit system that hosts the LEI server. Once installed, the iSeries Access ODBC Driver is listed as an available driver when creating a new DSN on the system. Hi We are working in a project where DB2 data from an IBM iSeries server (former AS400) is to be read from a Windows Server 2012 R2 64-bit machine with SQL Server 2016. The iSeries server is running on version 7.1 at the moment but will be upgraded to 7.3 in a couple of weeks. I have tried various packages from IBM iAccess for Windows and IBM iAccess Client Solutions, but drivers for OLEDB.
- Installing Ibm Db2 Driver Odbc Cli Windows
- Ibm Db2 Odbc Driver Install Windows
- Ibm Db2 Odbc Driver Windows 10 Download
Question & Answer
Question
Oct 29, 2008 The DB2 ODBC driver from Microsoft is bundled with MS Host Integration Server. It does not come out of box in Windows or with 'DB2 Connect'. Please see the following link for more info regarding HIS server. Microsoft HIS 2004 Pricing and Licensing FAQ.
When creating a new data source name (DSN) on a Microsoft Windows 32-bit system to access the iSeries server that hosts Lotus Enterprise Integrator (LEI), you do not see the iSeries Access ODBC driver listed as an available driver. Where can you find this?
Cause
The IBM iSeries Access for Windows client isn't listed if it is not installed on the 32-bit system. Windows 32-bit systems will not normally show an ODBC driver option for iSeries when creating a new DSN via the ODBC Data Source Administrator tool.
Answer
![Driver Driver](/uploads/1/2/4/8/124879728/862420456.png)
As noted in the LEI Installation Guide, Chapter 2, System Requirements section:
- Client libraries of the external systems to be accessed must be installed on the LEI server machine as well as the Domino server machine, if separate.
To access DB2/400 data on an iSeries system with an ODBC Driver, you must install the appropriate iSeries Access for Windows client on the 32-bit system that hosts the LEI server. Once installed, the iSeries Access ODBC Driver is listed as an available driver when creating a new DSN on the system.
For general information, refer to the IBM i Access for Windows site. For installation information including where to source the image, refer to Installing IBM i Access for Windows on the PC.
![Driver Driver](/uploads/1/2/4/8/124879728/183648215.gif)
(IBM does not plan to support IBM i Access for Windows on operating systems beyond Windows 8.1. The replacement product is IBM i Access Client Solutions (ACS), which includes 5250 emulation, data transfer, printer output, console support, and more. For information regarding IBM i Access Client Solutions, refer to http://www.ibm.com/systems/power/software/i/access/solutions.html )
Internal Use Only
Contributor: Michael Gilley, per his tech review.
![Saraswati chandra episode 42](https://s1-ssl.dmcdn.net/DjM5I/526x297-Sif.jpg)
Installing Ibm Db2 Driver Odbc Cli Windows
When creating a new data source name (DSN) on a Microsoft Windows 32-bit system to access the iSeries server that hosts Lotus Enterprise Integrator (LEI), you do not see the iSeries Access ODBC driver listed as an available driver. Where can you find this? [{'Product':{'code':'SSKTXK','label':'IBM Enterprise Integrator for Domino'},'Business Unit':{'code':'BU003','label':'Collaboration Solutions'},'Component':'ODBC','Platform':[{'code':'PF012','label':'IBM i'},{'code':'PF033','label':'Windows'}],'Version':'8.0;7.0;6.5','Edition':'}]
Ibm Db2 Odbc Driver Install Windows
Document Information
Ibm Db2 Odbc Driver Windows 10 Download
Modified date:
16 June 2018
16 June 2018