Solved: IBM DB2 Connection - Page 2

robarivas · ‎11-01-2016

Hello. I'm using Microsoft's built-in connector in Power BI to try to connect to an IBM DB2 database (for z/OS mainframe). However, I'm getting the following error message:

"Microsoft Db2 Client: The package corresponding to an SQL statement execution request was not found. SQLSTATE=51002 SQLCODE=-805".

Am I doing something wrong? Is there something specific I need to communicate to my DBA? Or is this a problem with the Power BI product? I'm using the October 2016 release of Power BI.

Thanks so much for any assistance.

Anonymous · ‎07-18-2017

I recently had to help a group of clients connect, and we found that the following conditions were necessary:

1) You must have the DB2 client installed on the machine from which you are trying to connect

2) Under Advanced Options in the Power BI connection dialog:

a) You have to use the Microsoft driver (as you mention)

b) You have to uncheck the "Navigate Using Full Hierarchy" option

3) You need to connect using the Database tab (not the Windows tab) and use your MF credentials

Without all of these in place, we had to use ODBC to connect.

FWIW, the view provided form the MF was basically just a selection of tables -- no individual columns were selectable.

View solution in original post

IBM DB2 Connection

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024