Win7 x64 IIS OleDB Jet 4.0 Error

[KoBE]

I recently upgraded my computer. I went from a x86 Win XP to a x64 Win 7 laptop.

When moving some of my ASP.Net projects over... I got an error saying: "The MicrosoftJet.OLEDB.4.O provider is not registered on the local machine."

This seemed odd to me because it should have been installed/registered with Access. After trying to register it manually, I still had no luck. Some quick googling later and it appears that the dll's are 32bit processes (I believe there are some beta x64 bit you can download).

So to over come this: Simply change the app pool pipeline to 'Classic' instead of 'Integraded'

[Nuno Brito]

Thanks for posting this tip. :)