Error when trying to connect to IBM DB2

[mckinzie]

I'm getting an error when trying to connect to our IBM DB2 database.  I removed the IP in the error below.  Anyone have any ideas? I don't see anywhere to enter a port number if we need to.

Details: "IBM DB2: ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "IP removed". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001
<br>"

[robarivas]

I'm getting a similar (I think) error:

"IBM DB2: ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "SSL". Communication API being used: "SOCKETS". Location where the error was detected: "SOCKETS". Communication function detecting the error: "sqlccSSLSocketSetup". Protocol specific error code(s): "410", "", "". SQLSTATE=08001"

At a minimum I'd desperately like to know which of the following I need to focus my attention on to fix this: my company's DBA group, local machine (i.e., software set-up/configurtion issues), or Microsoft's Power BI team (maybe a connector flaw?).

[raju19db]

By default when you choose IBM Provider the "Encrypt Connections" is still checked by Power BI Desktop.  Here is what i did to get it working.

> Go to File --> Options and settings -> Data source Setting.

> You would see the Data source for which you recieved this error.

> Select the data source and select "Edit Permissions"

> You would notice "Encrypt connections", Uncheck it.

> Click Ok and close.

> Start over, by getting data from DB2 and provide same data source information. This time you would not get "Protocol specific error code(s): 410.

I notice that if you use .Net provider when you select DB2 the .Net Provide prompt you to disable the encryption and hence the .Net provider will work.  

[Anonymous]

Hi,

I am trying to connect Power BI with IBM DB2 for Direct Query. The required driver has been installed but it still cannot connect to IBM DB2 server. When I tried to connect with Microsoft .Net Framework, it is not connecting as well. I checked in the command prompt, and it shows .net framework 4.8 is being installed wherein, 4.5 or higher verison is required. Can anyone please help me on this?

I am countered with the below error:- 

"Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001"

[mikes2nd]

This is a refused connection on the DB2 side for the 10061 error. usually means wrong port number.

http://www-01.ibm.com/support/docview.wss?uid=swg21164785

410 is another error and it states SSL error.

[Greg_Deckler]

You could try [IP]:[Port] for the server entry. Have a look at these two articles for a warning about Windows 8 and DB2 (not sure if you are using Windows 😎

https://support.office.com/en-us/article/Connect-to-an-IBM-DB2-database-Power-Query-0163e2e8-2944-4f...

And this one for troubleshooting connectivity:

http://blogs.technet.com/b/powerbisupport/archive/2014/01/09/connectivity-101.aspx

[mckinzie]

Hi everyone,

Thank you for the responses!  I have tried using the [IP]:[Port] and [Servername]:[Port].  I'm on Windows 7.  Thank you smoupre, I'll check out those links.

I'll post back when a resolution is found.

[Anonymous]

Hi mckinzie,

Did you finish your test ? Something new on your issue ?

Thanks,

Alexander.

[ElsD]

HI,

I tested servername:port, but still the same error.

I tried " telnet servername port" to see if there was a firewall issue, but that test is ok.

servername : port gave another error (The service "port" was not found)

I have windows 7.

Br

[robarivas]

Hello @ElsD and @Greg_Deckler

Any resolution on this??

[PowerBIGuy]

Have you tired using [servername]:[portnumber] as the server name?