nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to: configure ODBC connection to DB2 on iSeries

Hans020

Hi,

I'm trying to read data from a DB2 table on the iSeries platform. The following link (https://help.alteryx.com/2018.2/DataSources/DB2.htm) directed us to the IBM site. From that site, we downloaded and installed IBM Data Server Driver for ODBC and CLI (Windows AMD64 and Intel EM64T), Version 11.5.

In the ODBC Data Source Administrator we can see the driver was added:

When we create a new data source with this driver and click connect button to test the connection, the following error shows:

Does anyone have any experince in setting up an ODBC connection to a DB2 iSeries database?

is any additional configuration required?
In advanced settings, do we need to configure any CLI Parameters?
does anyone have a sample db2cli.ini for accessing DB2 on iSeries?

Any help is appreciated.

Regards,

Hans

Settings

Installation

Database Connection

Accepted answers

WilliamRang

Hello @Hans020 ,

here is a configuration which has worked on a iSeries DB2 over AS400:

(If this post helps, then please consider Accept it as the solution to help the other members find it more quickly).

All comments

WilliamRang

Hello @Hans020 ,

here is a configuration which has worked on a iSeries DB2 over AS400:

(If this post helps, then please consider Accept it as the solution to help the other members find it more quickly).

Hans020

Hi @WilliamR,

By mistake I pressed the Accept as Solution button....

Are you saying that we have the wrong driver for iSeries? What we installed is version 11.05.00.1077.....Yours is showing 13..., DLL file is also different.

Do you happen to have a link to where we can download the one you have from IBM site?

Do you have some sample screenshots of what to configure in Alteryx to have a succesfull connection?

Regards Hans020

bcgoh

Thanks Much. This really solved the issue. In case if you want to know where to download the driver.
You can refer to this link --> https://www.ibm.com/support/pages/ibm-i-access-client-solutions

Also this video help alot in setting up the driver as well --> https://www.youtube.com/watch?v=_zzbx9puBrM

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15911

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703