The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered

Category: sql server dataaccess


ganapathys_s on Sat, 21 Jul 2018 22:51:20

I have sql server in backend (server name B) & front end i am executing (Server A) though SQL management studio 2017 (SQL server is 2016 64 bit), i have installed access database engine 2013 & 2016 64 bit along with ms office 64 bit.

Still i see the error "

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.

" could someone assist how to fix this.



Visakh16 on Sun, 22 Jul 2018 05:10:09

SQLServer Management Studio (SSMS) is a 32 bit application. So you need to install 32 bit version of access database engine if you want it to work with SSMS.

Mohsin_A_Khan on Sun, 22 Jul 2018 05:39:49

Can you post your query? Are you using "OPENROWSET" or "OPENDATASOURCE"? If so, have you enabled "Ad Hoc Distributed Queries" on your SQL instance?

Anyway, the following link has a couple of solutions that many folks have accepted as the solution. You might want to take a look.

Hope this helps!