August 26, 2014

Microsoft.Jet.OLEDB.4.0 provider is not registered

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

Resolution:
There is no chance to use of Microsoft.Jet.OLEDB.4.0 and Microsoft Access Files like mdb file on 64bit Windows

Solution 1:
Right Click on Project > Properties > Build > Change Platform Target to x86 and recompile it again

Solution 2:
Go to App.config and change ConnectionString from Provider=Microsoft.Jet.OLEDB.4.0 to Provider=Microsoft.ACE.OLEDB.12.0

No comments: