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

 

 

Recently I deployed an aspx web application that is running OK on a 64 bit Windows 7 system. The web page would open Ok but trying to run a part of application that would read a csv/Excel file and parse it, using win forms application I am getting the above error message.

The fix involved two things:

1. Rebuilding the application specifically for 32 bit system. To do this for a VB.NET project, open project properities, select Compile tab, click on ‘Advanced Settings’ then select x86 for the system (not "Any CPU").

or

In case of Web project

2. On IIS system on the server, on the application pool for this application, select properties and then tick on "Enable 32 bit applications".