Forum Discussion

aogland's avatar
aogland
New Member
9 years ago

Issue connecting Power BI Desktop to IBM DB2 database

I am not able to connect my Power BI Desktop to a IBM DB2 database.

If I only add the server name and database I get an "Microsoft Db2 Client: No connection could be made because the target machine actively refused it 155.209.240.10:50000 SQLSTATE=08S01 SQLCODE=-1037".

I was told to use port 8471, and adding server:port I get another error. 

I have tried using both IBM and Microsoft Driver. 

On next page I have added "Database" user that works with ODBC/WinSQL as we do not have the same 

 

Using IBM Driver I get "DB2: We were unable to find a database provider with invariant name 'IBM.Data.DB2'" and I tried to install the recommended "Data Server Driver Package (DS Driver)".

 

Is there any guide, or anyone that have had issues that can share what they did to get it to work? 

 

 

The server is hosted at a hosting partner. 

 

I can connect using ODBC but then we need to install Client Access to all users, and it is working really slow. 

21 Replies

  • REKLP's avatar
    REKLP
    Helper I
    7 years ago

    Please upvote the question if you're having the same issue.

  • aogland's avatar
    aogland
    New Member
    9 years ago

    I am not able to connect my Power BI Desktop to a IBM DB2 database. If I only add the server name and database I get an "Microsoft Db2 Client: No connection could be made because the target machine actively refused it 155.209.240.10:50000 SQLSTATE=08S01 SQLCODE=-1037". I was told to use port 8471, and adding server:port I get another error. I have tried using both IBM and Microsoft Driver. On next page I have added "Database" user that works with ODBC/WinSQL as we do not have the same Using IBM Driver I get "DB2: We were unable to find a database provider with invariant name 'IBM.Data.DB2'" and I tried to install the recommended "Data Server Driver Package (DS Driver)". Is there any guide, or anyone that have had issues that can share what they did to get it to work? The server is hosted at a hosting partner. I can connect using ODBC but then we need to install Client Access to all users, and it is working really slow.

    • v-sihou-msft's avatar
      v-sihou-msft
      Microsoft Employee
      9 years ago

      aogland

       

      Make sure the instance is running on the server. TCP /IP services are started on remote DB2 server. Port number is correct and it's open on server.

       

      I just tested with server name and database name. It can connect the DB2 database properly.

       

       

       

      Regards,

      Simon Hou

      • robarivas's avatar
        robarivas
        Post Patron
        9 years ago

        Hello aogland, v-sihou-msft, and Greg_Deckler

         

        I still cannot get the connection to work. Anyone have any idea what I might be doing wrong?? I've installed the IBM Data Server Driver Package software and I've specified the correct server and port and database name. What else am I supposed to do?

         

        I keep getting the following error using the IBM driver:

             We were unable to find a database provider with invariant name 'IBM.Data.DB2'

         

        Using the MIcrosoft driver I get:

           The package corresponding to an SQL statement execution request was not found. SQLSTATE=51002 SQLCODE=-805

    • afsantos68's avatar
      afsantos68
      New Member
      5 years ago

      database name is the same as a name of one library? if not, how can i know the database name? thanks

  • ahilansinn's avatar
    ahilansinn
    New Member
    7 years ago

    Running into the same issue - is there a resolution for this? Can anyone help?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I also have the same problem with connection to DB2 from PBI.

     

    Using Microsoft driver:

    Details: "Microsoft Db2 Client: No connection could be made because the target machine actively refused it xxx.xxx.xxx.xxx:xxxx SQLSTATE=08S01 SQLCODE=-1037"

     

    Using IBM driver:

    Communication protocol being used: "TCP/IP".  Communication API being used: "SOCKETS".

     

    I have tried to connect trough Microsoft Excel with success. Have anyone found a solution for this?

    • BjoernSchaefer's avatar
      BjoernSchaefer
      Helper II
      7 years ago

      Hey Anonymous and everybody else in this thread. 

       

      For me, it works for nearly a year. I'm using the MS-Driver. Important is, that i have to use Port 446, for whatever reason. The other thing is, that PBI Desktop is having a hard time, since the December '18-Update, to refresh Tables from IBM DB2 Databases. The refresh takes, like, forever. Right now, I'm running a refresh for 6 (!) hours. I already opened a Support-Ticket and will keep you up to date in this Thread.

       

      https://community.powerbi.com/t5/Issues/Slow-DB2-refresh-Power-BI-Desktop/idi-p/602152

       

      Regards

       

      BjoernSchaefer

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I know this thread is a year old, but I'm experiencing the same issue. Did anyone have any luck fixing this issue? I've uninstalled, rebooted, reinstalled, rebooted, jumped on one leg...nothing works.

         

        Anyone?

  • muchinski's avatar
    muchinski
    Resolver II
    3 years ago

    For the error "DB2: We were unable to find a database provider with invariant name 'IBM.Data.DB2'", can you try to uninstall the IBM Driver and reinstall it?

    BUT at this time, use "Run as administrator" when runing the installer.

    Also, be sure to download the 64-bit version!

    Afte that, please check If the Driver was installed corretly:

    [System.Data.Common.DbProviderFactories]::GetFactoryClasses() | ogv

    It should return something like that:

     

     

    (I had the same error and it solved for me)