none
Connecting to DB2 from PowerPivot

    Question

  • 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 

    directories

    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

Answers

All replies

  • It is probably mixed bitness of driver and SQL Server.  You said you have 32-bit Windows; you need to make sure the connection type is 32-bit as well.

    Try that, and post back if you need more help.


    Ryan Shuell

    Wednesday, April 25, 2012 9:33 PM
  • which is the case. my driver is 32 bit. is there any registry entry / etc which I can check to ensure that the driver is registered?

    MSDNStudent Knows not much!

    Thursday, April 26, 2012 5:25 AM
  • could you please refer the given link.

    http://www.keepitsimpleandfast.com/2011/04/how-to-change-database-for-your-power.html

    Wednesday, May 02, 2012 9:54 AM
  • which is the case. my driver is 32 bit. is there any registry entry / etc which I can check to ensure that the driver is registered?

    MSDNStudent Knows not much!


    MSDN Student,

    Is this still an issue?

    Thank you!


    Ed Price, SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Monday, October 28, 2013 7:11 AM
    Owner