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

Category: sql server dataaccess

Question

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.


Ganapathy

Replies

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.

https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-quotthe-microsoftaceoledb120-provider-is-not-registered-on-the-local?forum=vstsdb

Hope this helps!