Forum Discussion
Cannot connect to AS400 via IBM DB2 database
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
I got it to work yesterday.
Get data
Ibm db2 database
Connect
Server: servername:446
Database: databasename
Next
Select Database tab on left
User name (try your own but I used qsecofr)
Password (try your own but I used the qsecofr password)
I changed the “select which level to apply to” to “servername:446;databasename
Hit connect
Hit ok for no encryption support
And I got data
Great! Thanks, I just tried it myself as well and it works indeed! Thank you so much for sharing this!