1

I am working with MS Excel files in my web application is hosted on Azure

I never run into following error when I am trying to access the excel file on my development fabric, but once I deploy to Azure, I get this error message.

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

I do not want to change my code and cannot use any 3rd party tool. My questions are:

  1. Is there a way around this issue?
  2. Can I create a VM on Azure, install the OLEDB Driver and upload my site there?
Robert MacLean
  • 38,975
  • 25
  • 98
  • 152
Tushar Narang
  • 1,997
  • 3
  • 21
  • 49
  • possible duplicate of [Windows Azure remote site The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine](http://stackoverflow.com/questions/21153308/windows-azure-remote-site-the-microsoft-ace-oledb-12-0-provider-is-not-registe) – Robert MacLean Dec 04 '14 at 09:35

2 Answers2

1

No such support is there. I guess the development fabric is flawed in this area of azure

0

You can do anything with an Azure VM that you can with a local machine :)

Just create one through the portal, login to it and go here:

http://www.microsoft.com/en-au/download/details.aspx?id=13255

Based on this post you may also need to download SQLEXPR_x86_ENU.exe from here and tick Allow In Process calls in the provider.

Community
  • 1
  • 1
Matt Davies
  • 1,259
  • 10
  • 10
  • Sir , I am getting this problem on my Azure Website not on my Azure VM. Can u explain how can I deploy my website on azure via The Azure VM – Tushar Narang Apr 30 '14 at 04:26
  • @tusharnarang Here's a great post I usually point people to for that: http://www.nimbo.com/blog/how-to-setup-an-azure-virtual-machine-as-a-web-server/ – Matt Davies May 05 '14 at 05:28