Click here to Skip to main content
15,888,527 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.
Posted
Updated 17-Aug-19 5:42am

1 solution

If SP_Configure has been done, and the correct ACE driver installed (32/64 bit), then the next step would be a permission issue.

References:
SQL Authority | Cannot initialize the data source object of OLE DB provider...[^]
Stack Overflow | The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server...[^]
 
Share this answer
 
Comments
Maciej Los 19-Aug-19 3:08am    
5ed!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900