Forum Discussion
Error when trying to connect to IBM DB2
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>"
10 Replies
Have you tired using [servername]:[portnumber] as the server name?
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 8)
And this one for troubleshooting connectivity:
http://blogs.technet.com/b/powerbisupport/archive/2014/01/09/connectivity-101.aspx
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.
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?).
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.
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.
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"
