openOleDBConnection The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine
I have just completed a migration for a friend of mine. As he is upgrading the server from Windows 2003 32bit to 64bit version, the site was hit with alot of errors not loading the right stuff for his .aspx files.
The following error was presented to me when trying to login to his administrative panel.
openOleDBConnection The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine
Let me present you the solution:
http://support.microsoft.com/kb/894435
You need to convert the ASP.NET installation to 32bit version.
After which, type “iisreset” in the cmd prompt to restart your IIS services.
One last step which was not shown on the web, you need to go to IIS ->Web Service Extensions -> Enable “ASP.NET v2.0.50727 (32-bit)”
One last time, type “iisreset” in the cmd prompt to restart your IIS services.
Now your site should be functioning properly now.
Enjoy!