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

This error you can get while compiling an application in machines like x64 or x86.

There are two solutions to it :

 

1) If you are in development (Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine)

To solve this issue open the project in Visual Studio then:

1. From the solution explorer right-click on project name then click on Properties

2. Click on the Build tab

3. Change Platform target from: Any CPU to x86

4. Re-build your solution

5. You are good to go

 

2) If your application is hosted on IIS(Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine)

This will happen if you have an Ms Office application/DLL incorporated in you application, Very simple steps

1) Open IIS manager

2) Select Application Pools

3) Select the application pool you are using in your website

4) Click on Advanced Settings in the right-pane of the window.  

5) Under General section, set "Enable 32-Bit Applications" to "True".

6) Done.