which dll need to put on server bin to fix Microsoft.ACE.OLE

Question

the problem on server is The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. i have tried a lot but still not working..any suggestion??? which dll need to put on bin file...(I am using import). Here i am using 64bit with 32 bit office.

Amit Kumar · Answer

hi If you get this error when trying to use ACE from an ASP.NET application the most likely cause is that you have installed either one of the 32-bit versions. By default IIS on a 64-bit operating system will run applications in a 64-bit worker process. 64-bit processes cannot load 32-bit DLLs. When a call is made to the ACE provider the 64 bit process will attempt to locate a 64-bit DLL. If it doesn't exist you get the error message that brought you here. For more details use it. https://www.mikesdotnetting.com/article/280/solved-the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine

Praveen Kumar · Answer

Open below url https://www.microsoft.com/en-us/download/details.aspx?id=13255 and download 32-bit version  install it. Check once now.

Manoj Maharana · Answer

i have already downloaded...but not working

Manoj Maharana · Answer

which type of dll needed?? How do i solve?? The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. any suggestion?? what should i do??