cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tkaihock Frequent Visitor
Frequent 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 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 11
Community Support Team
Community Support Team

Re: IBM DB2:"Microsoft Db2 Client: The request for the host resource failed. SQLSTATE=HY000 SQL

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?

IBM_DB2

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tkaihock Frequent Visitor
Frequent Visitor

Re: IBM DB2:"Microsoft Db2 Client: The request for the host resource failed. SQLSTATE=HY000 SQL

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

 

Community Support Team
Community Support Team

Re: IBM DB2:"Microsoft Db2 Client: The request for the host resource failed. SQLSTATE=HY000 SQL

Hi @tkaihock,

 

I'm afraid the version of DB2 matters. Do you have the older one?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tkaihock Frequent Visitor
Frequent Visitor

Re: IBM DB2:"Microsoft Db2 Client: The request for the host resource failed. SQLSTATE=HY000 SQL

hi @v-jiascu-msft,

 

My version is 9.7. Can this version work?

Thanks.

Community Support Team
Community Support Team

Re: IBM DB2:"Microsoft Db2 Client: The request for the host resource failed. SQLSTATE=HY000 SQL

Hi @tkaihock,

 

It should work. Please refer to this post. Finally I would suggest you open a support ticket here.

 

Best Regards,

Dale

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tkaihock Frequent Visitor
Frequent Visitor

Re: IBM DB2:"Microsoft Db2 Client: The request for the host resource failed. SQLSTATE=HY000 SQL

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

tkaihock Frequent Visitor
Frequent Visitor

Re: IBM DB2:"Microsoft Db2 Client: The request for the host resource failed. SQLSTATE=HY000 SQL

Hi @v-jiascu-msft,

 

After some investigation, I realized that using Microsoft driver for IBM DB2 datasource, I can connect to the databases under the default instance, but not databases under the other instances. Have you tried connecting to databases under non-default instance using Microsoft driver? 

Thanks.

Community Support Team
Community Support Team

Re: IBM DB2:"Microsoft Db2 Client: The request for the host resource failed. SQLSTATE=HY000 SQL

Hi @tkaihock,

 

The secret could be in the connect string. Maybe it's something like it in the SQL Server: ServerName\Instance. Please try out a different string for the Server. Related documents: Configuring access to DB2 databases and Designing instances.

IBM_DB23

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tkaihock Frequent Visitor
Frequent Visitor

Re: IBM DB2:"Microsoft Db2 Client: The request for the host resource failed. SQLSTATE=HY000 SQL

Hi @v-jiascu-msft,

Thanks for your reply. I briefly tried but cannot seem to make it work. But I manage to work around by just using ODBC. Thanks!