robarivas's avatar
robarivas
Icon for Post Patron rankPost Patron
9 years ago
Status:
Needs Info

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

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.

Data Modeling

8 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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?

     

     

    Best Regards,

    Herbert

  • robarivas's avatar
    robarivas
    Icon for Post Patron rankPost Patron
    9 years ago

     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's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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's avatar
    robarivas
    Icon for Post Patron rankPost Patron
    9 years ago

    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's avatar
    robarivas
    Icon for Post Patron rankPost Patron
    9 years ago

    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's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
    robarivas
    Icon for Post Patron rankPost Patron
    9 years ago

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

Completed Ideas