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 ge...
Need Help
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!

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

      Hi robarivas,

       

      Sorry for the late response. I would suggest you create a support ticket at the end of this site, let the engineer look into the your real environment.

       

      Best Regards,
      Qiuyun Yu

      • jspowerbi's avatar
        jspowerbi
        Icon for Advocate II rankAdvocate II
        9 years ago

        Does anyone know of any update on this?  I'm able to connect to my ODBC source on a Windows 7 Machine via PowerBI desktop.  However, when I try conencting on a Windows 10 machine, I get this same error. Though, I'm able to connect to the ODBC source through Excel on the Windows 10 machine.