Cannot connect to AS400 via IBM DB2 database

[Urid1969]

Hello friends

Keep getting error while trying to connect to AS400 

[wimbor]

Same issue here.  Our PaaS supplier gave the same answers:

- on iSeries / AS/400 DB2 uses a different port

- use ODBC: that will work.

But that is indeed a sub-optimal solution.

It would be nice if Microsoft could adapt the DB2 driver in such a way that a connection is possible.

[v-yuezhe-msft · Accepted solution]

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

[robarivas]

I haven't been able to connect to DB2 either. I've been trying to work with Microsoft on the issue. Hopefully something comes of it. My DBA's just want to force me to use ODBC but ODBC performance seems inacceptably slow for me. The DBA claims that Microsoft told them the built-in connector to DB2 won't work, which seems implausible, and because ODBC "works" the DBA doesn't want to revisit the issue.

Anyway, in your instance you might try adding the port number to the end of your server name. I've heard 446 is a common port number, although as I said nothing's worked for me so far. In the server field type the following

   whatever_your_server_is:446

[Urid1969]

Yes, I tried adding a port still error. Thank you