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...
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-msft
Microsoft Employee
Microsoft Employee- v-jiascu-msft
Hi Dale,
I just realized my DB2 .NET data provider version is 9.7. Below mention need at least 10.1. I will work on getting the upgraded IBM Data Server Driver. Thanks.
https://docs.microsoft.com/en-us/power-bi/desktop-data-source-prerequisites