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!

Answer 1

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

Answer 2

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!

Answer 3

could you please refer the given link.

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