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  [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
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:
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 tested servernameort, 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.
I'm getting a similar (I think) error:
"IBM DB2: ERROR  [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.
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.
Find out how to participate in the first Power BI 'Can You Solve These?' challenge.
Get your latest community news and announcements.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Each week, complete activities and be qualified in the drawing for cool Power BI Swag.