Forum Discussion

robarivas's avatar
robarivas
Icon for Post Patron rankPost Patron
9 years ago
Solved

IBM DB2 Connection

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:...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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. 

     

     

     

     

fherrera's avatar
fherrera
Frequent Visitor
9 years ago

I have the same error. I can't connect to IBM DB2 with the new version of Power BI Desktop 2.42.4611.701 32 bit (enero de 2017).

 

I will be possible that this new version it doesnt have some package that DB2 need to connect to?

 

I was reading that maybe with the IBM Data Server Driver Package this error will be fixed, but, it didn't work.

 

Did someone found the solution?

 

 

 

fherrera's avatar
fherrera
Frequent Visitor
9 years ago

I tried to connect to DB2 with an old version of Power BI Desktop (september 2016) and I can connect to DB2.

 

 

 

So, my hipotesis is correct? The new version of PBI Desktop doesn't have the package to connect tot DB2?

  • Steve12345's avatar
    Steve12345
    New Member
    9 years ago

    Greetings - any answer to this issue?  I have tried both versions (Oct 2016 and Feb 2017) and they both work.  However I have a 3rd installation (2017) on a third machine that does not work.  The two that work are on a 4 year old Dell latitude 64 bit Iin 7 upgraded to Win 10 and a Surface Pro 3 Win 8.1 upgraded to Win 10.  both have .Net 3.5 and 4.6.  The machine that does not work is a Surface Pro 4 native Win 10 also with .Net 3.5 and 4.6.

     

    Help?

     

    Thx - Steve

     

     

  • Steve12345's avatar
    Steve12345
    New Member
    9 years ago

    Greetings - any answer to this issue?  I have tried both versions (Oct 2016 and Feb 2017) and they both work.  However I have a 3rd installation (2017) on a third machine that does not work.  The two that work are on a 4 year old Dell latitude 64 bit Iin 7 upgraded to Win 10 and a Surface Pro 3 Win 8.1 upgraded to Win 10.  both have .Net 3.5 and 4.6.  The machine that does not work is a Surface Pro 4 native Win 10 also with .Net 3.5 and 4.6.

     

    Help?

     

    Thx - Steve

     

     

    • fherrera's avatar
      fherrera
      Frequent Visitor
      9 years ago

      Hello Steve,

       

      Could you try to connect to DB2 with the september 2016 version, please? You tried with the october version and I think in the october version it cant connect to DB2.  

      • Steve12345's avatar
        Steve12345
        New Member
        9 years ago

        Sorry but i do not have access to the September 2016 version.

         

        I have been able to connect to DB2 with both the Oct 2016 AND the Feb 2017 version (on two different workstations) so i do not think that it is a BI version issue.  I suspect that "something" is missing off of the problem workstation(s) but have no real idea what that might be...