question

ManasaPurkar-9537 avatar image
0 Votes"
ManasaPurkar-9537 asked MinxinYu-MSFT edited

ACE.OLEDB.12.0 provider issues on Windows Core machines

I have a Windows Core 2019 and 2016 machines.
I want to read Access DB on this machine.
When I have MS Access 2010 Redistributable installed (https://www.microsoft.com/en-in/download/details.aspx?id=13255) then I am able to open the access db file and read from it.
However , when I have MS Access 2016 Redistributable installed (https://www.microsoft.com/en-us/download/details.aspx?id=54920) , I am unable to open connection to the database.

I am using this connection string to connect to my access db.
Provider=Microsoft.ACE.OLEDB.16.0;Data Source=c:\FData.mdb;Jet OLEDB:Engine Type=5;

The application making the call just crashes and no exception is thrown.

Additionally , I tried to connect to this access DB file via UDL.While accessing this file from UDL using the ACE 12.0 provider , also causes the UDL to crash.

The drivers are seen in the Datasources checked via odbcad32.

I have a x86 application and checked the 32-bit UDL and Datasources through 32 bit odbcad32.

My query is , do I need to install anything additional to make this work ?
The connection string mentioned in both the URL's for the redistributable mentions connection string to be this : Provider=Microsoft.ACE.OLEDB.16.0;Data Source=c:\FData.mdb;Jet OLEDB:Engine Type=5;**. I am using the same during both my access db installers.

Can I use any other provider thats default installed on the core machine to access db ? ( e.g Jet Provider installed on windows machines ) ?

Do we have any provider logs or events that can be checked to troubleshoot the issue

Also
When downloading the Microsoft Access Database Engine 2016 Redistributable , in the system's requirement does not mention Windows 2019 and Windows 2016.
Could you please let me know the alternative to use this to access MS Access DB file programatically ?

I am unable to make my application work with 2016 , but same application works with Microsoft Access Database Engine 2010 Redistributable.

office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers