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

Tamilarasan Nallairusun 0 Reputation points
2023-08-25T05:57:27.31+00:00

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

User's image

Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,869 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ben Gimblett 3,410 Reputation points Microsoft Employee
    2023-08-25T11:10:12.7833333+00:00

    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.

    0 comments No comments