question

ManasaPurkar-9537 avatar image
0 Votes"
ManasaPurkar-9537 asked EricHallander-7264 answered

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











windows-server-core
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.

LimitlessTechnology-2700 avatar image
1 Vote"
LimitlessTechnology-2700 answered ManasaPurkar-9537 commented

Hello

Thank you for your question.

from the error it seems that it due to compatibility issue with application to MS Access 2016 Redistributable.

Alternatively, I recommend that you post your question on the windows 11 forum, because there you will be greeted by an engineer from the windows 11 team, who has more recent information to pass on to you, to do this just use the link below and select the top option called "Ask a question" and describe the entire problem, including images:


https://docs.microsoft.com/en-us/answers/products/dotnet

https://docs.microsoft.com/en-us/answers/topics/c++.html



--If the reply is helpful, please Upvote and Accept as answer--

· 1
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.

Thanks for the response. I will check with the Windows 11 team.

0 Votes 0 ·
EricHallander-7264 avatar image
0 Votes"
EricHallander-7264 answered

Was there some resolution found? I am reading this issue as you are attempting to open an Access database using the 365 drivers and the ADO library, and when you execute the Open call the program simply exits, as in there is something that can't be caught because it's trying to load something that it can't find. I am getting the same thing on a 2019 windowesservercore container.

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.