Forum Discussion
IBM DB2:"Microsoft Db2 Client: The request for the host resource failed. SQLSTATE=HY000 SQLCODE=-357
Hi,
I am trying to set up data source for IBM DB2 on Power BI service and encounter above error message.
Doing the same on PBI desktop using Microsoft driver yield the same error. However, using IBM driver on PBI desktop works well.
The problem is that I am unable to indicate to use IBM driver on PBI service via the gateway and I suppose the data source on PBI service is configure to use Microsoft driver. I checked, I have .Net 4.7 and the latest PBI desktop.
Please advise me if you have clues to resolve this issue. Thanks!
11 Replies
Hi tkaihock,
I have tested with the Microsoft Driver successfully. The coincidence is that I have the exact .net 4.5. Is this the cause? If it's possible for you to swich to .Net 4.5 for test?
Best Regards,
Dale
hi v-jiascu-msft,
Thanks for your reply.
I cannot figure out a way to switch back to .Net 4.5, seems to come default with windows 10.
My data gateway is installed on machine A and DB2 is on machine B. Do both machines require .Net 4.5 or only machine A?
Does the version of DB2 matter? https://docs.microsoft.com/en-us/power-bi/desktop-data-source-prerequisites
