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
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.

jspowerbi's avatar
jspowerbi
Icon for Advocate II rankAdvocate 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
    Icon for Post Patron rankPost 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
      Icon for Advocate II rankAdvocate II
      9 years ago

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