Forum Discussion

robarivas's avatar
robarivas
Post 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
Community 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
Advocate 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.

  • jspowerbi's avatar
    jspowerbi
    Advocate II
    9 years ago

    robarivas - out of curiousity, were you using a Windows 10 machine when you ran into this error? I'm running into the same thing..

    • robarivas's avatar
      robarivas
      Post Patron
      9 years ago
      Hello jspowerbi. I believe I overcame this particular issue by adding the Autocommitt=OFF parameter to my DSN. But to answer your question, yes I was using Windows 10.
      • jspowerbi's avatar
        jspowerbi
        Advocate II
        9 years ago

        robarivas the Autocommit = Off worked for me. Thanks so much!