Forum Discussion

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

ODBC IBM ERROR [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.

Need Help

9 Replies

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

    Although I desperately want to know what causes this problem I will say that if you're fortunate enough to have an older version of Power BI laying around then uninstalling the February 2017 release and using the older release makes this problem go away. So it seems fairly clear to me that the issue resides with Microsoft. Hopefully Microsoft will respond and/or a future update will correct the source of the problem. Otherwise I'll be stuck using the November 2017 for the foreseeable future. :smileysad:

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi robarivas,

     

    Did the same issue occur when you used IBM DB2 data source in Feb desktop? As you said the issue happened to your home PC, how about use ODBC data source in Feb desktop in company PC?

     

    Best Regards,
    Qiuyun Yu

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

      My  work PC has the November version. I don't have admin rights to install the February version to test it out. The connection on my work computer works fine.

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

        Hello v-qiuyu-msft. I tried deleting and rebuilding the DSN but it still didn't work. Is it possible to get support on this issue please? We cannot upgrade to the March version of Power BI until we know that the ODBC will work. (Even better would be for the DB2 connector to work...but that's a different thread/issue). Thanks so much!