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

Question

I have issue on when reading the csv file .

initially we have deployed the app in vm its working .then moved to app service now i get the below error

Answer 1

Hi @Tamilarasan Nallairusun thanks for the question. Pointing you here https://learn.microsoft.com/en-us/answers/questions/124687/why-microsoft-ace-oledb-12-0-is-not-working-for-re for the answer

More context: App Service runs in the Kudu sandbox - this is what differentiates App Service from running code on a VM. There's some tools available you can use that will help with assessing how suitable your App is to host on App Service and the changes/mitigation that may be required. The best starting place for that would be here https://azure.microsoft.com/en-gb/products/app-service/migration-tools/

As a general rule, you should look for machine dependencies (on Windows that would include COM, GAC, Registry ,Event Log etc) and machine drivers.