cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sgamage Frequent Visitor
Frequent Visitor

db2 connection error

Hello experts,

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?

 

 

Thanks

 

Sahan

9 REPLIES 9
Moderator v-yuezhe-msft
Moderator

Re: db2 connection error

Hi @sgamage,

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.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vmsouza30 Regular Visitor
Regular Visitor

Re: db2 connection error

 How do I execute this tests?

 

Do you have a documentation?

 

Vanice

Moderator v-yuezhe-msft
Moderator

Re: db2 connection error

Hi @vmsouza30 , @sgamage      

Please refer to the following articles.

https://www.ibm.com/developerworks/community/blogs/nix/entry/checking_whether_an_db2_instance_is_run...
https://www-304.ibm.com/support/docview.wss?uid=swg21264632
http://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.qb.server.doc/doc/t0004727....


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
krepko7 Frequent Visitor
Frequent Visitor

Re: db2 connection error

We are getting the same error during a client POC.  DB2 works fine when you pull data in Excel.  The sames doesn't work in Power BI.

mrohde Frequent Visitor
Frequent Visitor

Re: db2 connection error

Did anybody ever get this resolved?  I am having the same issue were I can connect to the source DB2 (iSeries) from Excel, Access, SQL but not Power BI.

Highlighted
Gowtham4446 Frequent Visitor
Frequent Visitor

Re: db2 connection error

No, Please anyone help me, i am also encountering the same error.

dgeiger Visitor
Visitor

Re: db2 connection error

Also having this error. Even within Power BI, I can connect to the same source with ODBC, but for reasons of filtering and number of results, would like to connect via Db2.

cavalierimauro Regular Visitor
Regular Visitor

Re: db2 connection error

Hi ! I need a solution on this issue, DB2 connector in Power BI is not working for me. Same error showed.

cavalierimauro Regular Visitor
Regular Visitor

Re: db2 connection error

Same error, can we have any solution for this??