I'm encountering an error when im trying to get data using the db2 connection: Microsoft Db2 Client: No connection could be made becasue the target machine actively refused it SQLSTATE=08S01 SQLCODE=-1037.
Does anyone have any advice on why this might be happening?
Do you get the above error when connecting to DB2 database from Power BI Desktop? If that is the case, could you please connect to DB2 database from other application such as Excel and check if it is successful?
According to the above error message, there are some proposals for you troubleshooting it.
a. Verify that if the DB2 server is up and running.
b. Check the port status by using “netstat” in your DB2 server and verify the port is in state Listen.
c. Include the port number in your connection string when connecting to DB2 database.
Hi @vmsouza30 , @sgamage
Please refer to the following articles.