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

  • aogland's avatar
    aogland
    New Member
    9 years ago

    I still have not got it to work.

    • dmontella's avatar
      dmontella
      New Member
      9 years ago

      Same exacct issue when connecting to DB2 from Power BI:

       

      Details: "IBM DB2: We were unable to find a database provider with invariant name 'IBM.Data.DB2'.
      This error could've been the result of provider-specific client software being required, but missing on this computer.  To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'IBM Data Server Driver Package (DS Driver)': https://go.microsoft.com/fwlink/p/?LinkID=274911"

      • ahilansinn's avatar
        ahilansinn
        New Member
        7 years ago

        Running into the same issues. Can anyone else here? 

  • Pablo_dediosIBM's avatar
    Pablo_dediosIBM
    New Member
    4 years ago

    Hola buen dia Robarivas, encontre los siguiente......

    cuando instalas el driver de IBM se tiene el problema de que el "InvariantName" que se le otorga al controlador toma la version: ejemplo

    aqui hay dos opciones, por el regedit cambies el nombre del inveriantname, solo que a futuro podria ser un problema....
    o que Microsoft actualice por algun parche esta conexion y busque el nombre completo que se le esta otorgando al conector...