Forum Discussion
tkaihock
8 years agoFrequent Visitor
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...
v-jiascu-msft
Microsoft Employee
8 years agoHi 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
- tkaihock8 years agoFrequent Visitor
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
- v-jiascu-msft8 years ago
Microsoft Employee
- tkaihock8 years agoFrequent Visitor