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!