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

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>"

9 REPLIES 9
PowerBIGuy Member
Member

Re: Error when trying to connect to IBM DB2

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

Business Intelligence Architect / Consultant
Super User
Super User

Re: Error when trying to connect to IBM DB2

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)

 

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

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

mckinzie Frequent Visitor
Frequent Visitor

Re: Error when trying to connect to IBM DB2

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.

Alexandre Frequent Visitor
Frequent Visitor

Re: Error when trying to connect to IBM DB2

Hi mckinzie,

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

 

Thanks,

Alexander.

ElsD Regular Visitor
Regular Visitor

Re: Error when trying to connect to IBM DB2

HI,

 

I tested servernameSmiley Tongueort, 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 Member
Member

Re: Error when trying to connect to IBM DB2

Hello @ElsD and @Greg_Deckler

 

Any resolution on this??

robarivas Member
Member

Re: Error when trying to connect to IBM DB2

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?).

mikes2nd Regular Visitor
Regular Visitor

Re: Error when trying to connect to IBM DB2

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.

raju19db Frequent Visitor
Frequent Visitor

Re: Error when trying to connect to IBM DB2

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.  

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 266 members 3,058 guests
Please welcome our newest community members: