Forum Discussion

mckinzie's avatar
mckinzie
New Member
10 years ago

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.   Detai...
Need Help
raju19db's avatar
raju19db
Regular Visitor
8 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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"