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

Srinath Gattu 1 Reputation point
2022-02-08T12:30:27.377+00:00

getting the this below error in ASP.net application but the same oledb is working in Windows application(same code.) can someone please help me in this

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

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,400 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 40,156 Reputation points
    2022-02-08T12:44:41.423+00:00

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

    Guess into the blue: Your Win App is 32 bit and you (may) have installed ACE as 32 bit data provider; that matches on bitness and works.
    You ASP.NET app is 64-bit and can't uses 32-bit data provider; that don't work and causes the error.

    Install additional ACE as 64 bit or let ASP.NET run as 32-bit app (not prefered).


  2. Dave Patrick 425.7K Reputation points MVP
    2022-02-09T16:37:03.733+00:00

    You can download both 32/64 bit versions here.
    https://www.microsoft.com/en-us/download/details.aspx?id=13255

    --please don't forget to upvote and Accept as answer if the reply is helpful--