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."

Microsoft 365 and Office | Development | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,516 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. Anonymous
    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--


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.