How to: configure ODBC connection to DB2 on iSeries
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Database Connection
- Installation
- Settings
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Hans020 ,
this is the configuration which has worked for 2 of our customers after many try of different driver version.
Sorry but I don't have any link to provide, you download the driver directly on IBM website.
The last information I can give you is this one: it has been configured with the 32bit ODBC Manager.
No special configuration just enter the name, user and password.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
