0 Kudos

ERROR [HY010] [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010

Status: Needs Info
by robarivas Member on ‎02-21-2017 05:43 AM

I used to be able to connect to my corporate zOS IBM DB2 database from my personal home PC through Power BI Desktop using ODBC (and only with ODBC for unknown reasons). Today, all of a sudden, I'm getting the following error:

 

ERROR [HY010] [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010

 

What's strange is that using Excel I can connect just fine to that database using the same ODBC driver.

 

So what's going on (all of a sudden) with Power BI Desktop and how do I overcome this frustrating obstacle?

 

Thank you.

Status: Needs Info
Comments
by Community Support Team
on ‎02-21-2017 11:14 PM

@robarivas

 

Did you use the same version of PBI Desktop when you connected to DB2 successfully/unsuccessfully?

Can you connect to DB2 with the built-in connector instead of ODBC?

 

ERROR [HY010] [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010_1.jpg

 

Best Regards,

Herbert

by Vicky_Song Established Member
on ‎02-21-2017 11:16 PM
Status changed to: Needs Info
 
by robarivas Member
on ‎03-08-2017 03:28 PM

 @v-haibl-msft

 

The only thing that "corrected" this was re-installing an earlier version of Power BI.

 

Never been able to connect with the built-in connector...only ODBC seems to work for whatever reason.

by Community Support Team
on ‎03-15-2017 01:48 AM

@robarivas

 

The Mar 2017 version of Power BI Desktop is available now. Could you please have a try with this new version?

 

Best Regards,
Herbert

 

by robarivas Member
on ‎03-15-2017 06:18 AM

Hello @v-haibl-msft

 

Thanks for following up. Unfortunately even with the March 2017 release the problem still remains.

 

I'm trying to fight the good fight to get my organization to embrace Power BI but extreme challenges with just basic connectivity make this an uphill climb to say the very least.

by robarivas Member
on ‎04-23-2017 10:35 AM

Hello @v-haibl-msft and @Vicky_Song. Tried April 2017 version and problem remains. Not good. Very disappointing.

 

Excel works so can't imagine why Power BI does not.

by pcgeekus Frequent Visitor
‎08-08-2017 03:10 PM - edited ‎08-08-2017 03:13 PM

I have the July install and have this same issue.

Robarivas, What's the most recent old version that worked?

 

Does anyone know how to find the system name for DB2 on zOS? All I have are ODBC DSN entries they have setup for us, but those don't seem to have the system in their config.

by robarivas Member
on ‎08-08-2017 03:16 PM

Added parameter Autocommitt=Off in the DSN to fix the issue.

Idea Statuses