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.