Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

robarivas

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

Submitted by Post Patron 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
See more ideas labeled with:
8 Comments (8 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎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

Vicky_Song
Impactful Individual
Impactful Individual
‎02-21-2017 11:16 PM
Status changed to: Needs Info
 
robarivas
Post Patron
Post Patron
‎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.

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎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

 

robarivas
Post Patron
Post Patron
‎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.

robarivas
Post Patron
Post Patron
‎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.

Anonymous
Not applicable
‎08-08-2017 03:10 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.

robarivas
Post Patron
Post Patron
‎08-08-2017 03:16 PM

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

Idea Statuses