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

Jeick's avatar
Jeick
Frequent Visitor
6 years ago

I discovered this old thread when I searched for the following connection error: 

The package corresponding to an SQL statement execution request was not found. SQLSTATE=51002 SQLCODE=-805

 

After some research i finally found the solution for my Power BI Version (May 2019):

It is not necessary to install and use the IBM DB2 driver package on your machine or to edit the default connection settings (Just enter the correct Hostname including Port and Databasename).

 

The user you use to connect to your DB2 database simply has not the needed privileges to install a certain package on your database essential to connect. It seems that Power BI automatically tries to install this package when you click "connect" for the first time.

 

When you login with an account that has admin privileges (or has the right to Install / Bind new packages) this package gets created in your DB2:

 

After installing this package every other database user can access this DB2 Data Source via Power BI!

 

This Link helped me:

https://docs.microsoft.com/bs-latn-ba/azure/data-factory/connector-db2

 

I hope this helps other people searching for the same error :)!