Connecting to DB2 from PowerPivot


  • I downloaded and installed the IBM DB2 client on my machine. The IBM.Data.Db2.Dll is located in my 

    C:\Program Files\IBM\SQLLIB\PDE_9_7_4\BIN\netf20 

    C:\Program Files\IBM\SQLLIB\PDE_9_7_4\BIN\netf40 


    However... when I try to connect to DB2 from powerpivot it says

    The 'DB2OLEDB' provider is not registered on the local machine

    now what can I do to register the db2 provider post the installation of the ibm db2 client on my windows 7 32 bit machine?

    MSDNStudent Knows not much!

    Wednesday, April 25, 2012 1:22 PM


All replies