ACE.OLEDB.12.0 provider issues on Windows Core machines

Manasa Purkar 1 Reputation point
2021-10-16T16:58:37.24+00:00

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.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
817 questions
0 comments No comments
{count} votes