The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine

Today I got this error "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine"  when running my ASP.NET web based application on my new laptop with Windows 7 64 bit. It was a form that allows user to upload excel file, then I read the data from excel file into data table object. It used to work in my old laptop, but not in my new one .

I have googled around for this issue, have found solution for it. So I took a note here for people who might face same problem as me.

Steps to fix this problem

• Open the IIS Manager
• Click on Application Pools
• Select your web application pool
• Click on the link "Set Application Pool Defaults" on the right hand side
• In General area, turn on "enable 32-bit applications"

Microsoft Jet OLEDB provider is not registered