Hi Dears,
I m having one issue with a procedure. My proc is for fetching all the details from .mdb file from the server and update in table. I m using this statement
OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'C:\filelocation\reportingfile.mdb'; 'Admin'; '',Sales)
What I have tried:
it was working before, recently we have updated the server to 2016. after updating our server, this is proc gives an error like,
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null).
i have installed access database engine 2016
i have configured all the settings like,
ad hoc queries settings.
But still the above error is occurred,
Kindly advise.