Search code examples
c#iisms-officeoledb

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

I get the following exception

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

though I have installed 

'Microsoft.ACE.OLEDB.12.0'
  • In my local dev machine I have also office 2010

What is wrong?

Solution

  • If you system is 64 bit,Then you have to change your pool settings to allow 32 bit applications that is OLEDB. ,then this link might help.

    http://help.webcontrolcenter.com/KB/a1114/how-to-enable-32-bit-application-pool-iis-7-dedicatedvps.aspx