Error only for Azure - provider "Microsoft.ACE.OleDb.12.0" is not registered on the local machine

Question

I work with MS Excel files in my web application built in Azure. I have never encountered the following error when I try to access an excel file on my development basis. But as soon as I deploy to Azure in the cloud, I get this error message.

The provider 'Microsoft.ACE.OleDb.12.0' is not registered on the local computer.

I got the impression that Azure development is a copy of the environment you expect in Cloud.

Is there something wrong I'm doing here? ACE.OleDb provider not present in Azure?

Answer 1

ACE.OLEDb Azure VM.

(, , ). Fabric .NET , GAC. , , GAC Azure. , Dev Fabric, , DevFab (SDK 1.2) ( ) .

, , DAC Jet Drivers. , , DLL, Azure, .

1.) , " " DLL

2.) (, ), DLL bin , GAC. DLL , .

, , DLL, Azure. , , .

Answer 2

, ( ).

http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en

Windows Azure.

Answer 3

, , .

, . , , . Windows Server 2008 (IIS , -).

, Azure, , , , , . , , , .Net, , " " true, . , , - , -.

Answer 4

. Azure, Azure Web-. Azure VM, .

OpenSDK, Excel OleDb.

, , , :

• https://www.microsoft.com/en-us/download/details.aspx?id=30425
• https://msdn.microsoft.com/en-us/library/office/hh298534.aspx?cs-save-lang=1&cs-lang=csharp#code-snippet-15
• Excel Open XML

Make sure that the open sdk dll is copied to the local one. In my case, this is a link to a DLL installed on my computer in program files. So when I uploaded to Azure, it gave a missed dll error. I copied the dll separately to the bin folder. I think that if we try to use nuget to refer to the dll, then this problem will not appear, but I have not tried it.

We hope this helps someone who is looking for an alternative to Oledb in case installing a DLL on the server is not possible.