Solve the problem with the supplier "Microsoft.ACE.OLEDB.12.0" without installing the "Microsoft Access Database Engine"

I am importing some data from MS-Excel in C #. When I deployed this application to my local server (IIS 7), I received the following error.

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

I installed the "Microsoft Database Database Engine" on the local server to solve this problem. Now that I have deployed my application to a remote server. I have the same error. Installing the "Microsoft Database Database Engine" on a real server is prohibited for security reasons.

My question is, is there any way to solve this problem from .dll (adding some project link) or in any other way.

+4
source share
1 answer

I had a similar problem. In my case, this was due to the fact that the target system was a 64-bit OS, and only 32 bits are available between DLLs. I solved the problem of changing the assembly configuration from "Any processor" to 32 bits.

I hope this helps your case as well.

+5
source

Source: https://habr.com/ru/post/1499533/


All Articles