Forum Discussion

Urid1969's avatar
Urid1969
Helper I
9 years ago
Solved

Cannot connect to AS400 via IBM DB2 database

Hello friends Keep getting error while trying to connect to AS400 
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Urid1969,

    Firstly, please check the IBM AS400 server status and port status as per the below steps.

      a. Verify that if the IBM server is up and running following the troubleshoot steps in this article.
      b. Check the port status by using “netstat” in your IBM server and verify the port is in state Listen.

    Secondly, choose each driver in the following screenshot when connecting to IBM database and check if it is successful. When you choose IBM, please ensure that you have IBM DB2 Data Server Driver installed on your computer (minimum requirement is the IBM Data Server Driver Package (DS Driver)). Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).


    Thirdly, check if you are able to connect to IBM AS400 database from other application such as Excel.

    Thanks,
    Lydia Zhang

wimbor's avatar
wimbor
Regular Visitor
9 years ago

Same issue here and we got the same response from our PaaS supplier:

- on iSeries (AS/400) DB2 is on a different port

- use ODBC

 

But that is indeed slower, plus it requires additional software.  That by itself can be overcome, if it weren't for the insane compatibility mess that IBM software is.  You need that version of that software that is only compatible with this Windows version, but the data driver is a different version and that is not compatible with the plugin for Visual Studio, etc. etc, ... Combine that with endless vague support documents and you spend hours researching the stuff, without making any progress.

 

Microsoft could help us a lot by simply allowing a different port in their own DB2 connection driver. Then I could toss all of this iSeries access mess out the door. :-)