Forum Discussion
Post PatronODBC no longer works
I used to be able to connect to my corporate zOS IBM DB2 database through Power BI Desktop using ODBC (and unfortunately only with ODBC for unknown reasons). Since the February 2017 version of Power BI I can no longer see any views or tables in Navigator and instead 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/DSN. Older versions of Power BI work fine...the problem is with the February, March, and April 2017 releases.
So what's going on with Power BI Desktop and how do I overcome this frustrating obstacle?
Thank you.
5 Replies
My guess is that PowerBI may have upgraded to ODBC 3.8 and you may need a 3.8 IBM DB2 ODBC driver. You can generate an ODBC trace log to confirm, or grab a trial of the DB2 for z/OS ODBC driver from DataDirect to try as a diagnostic test.
robarivasThanks for the reply SAsInSumit. I downloaded the DataDirect software but couldn't quite figure out how to configure the DSN correctly so I wasn't able to test the theory about ODBC 3.8. Also, I'm not sure how to generate the trace log or what to do with it even if I generated it.
Why would IBM's ODBC driver software that they offer on their website not be 3.8 or compatible with 3.8?
Are there any other ways to get ODBC 3.8?
The DataDirect driver connects directly to the mainframe over the wire so it will need the physical database connection information which may be different than what you've configured.
Unless someone else has a suggestion, I'll see if I can try it out against the latest Power BI version against our z/OS mainframe.
