Thursday 3 April 2014

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine error

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine error
Solution:
Please make sure that you have installed AccessDatabaseEngine.exe provider with proper version (32 or 64bit version based on the office version installed) on the sql server machine.
You can download from below link.
http://www.microsoft.com/en-in/download/details.aspx?id=13255