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 ...
robarivas's avatar
robarivas
Icon for Post Patron rankPost 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

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