I have been trying to create MS Access Database Linked Service in Azure Data Factory.
I have used the below formats for creating the MS Access linked services in Azure Data Factory:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\server\share\folder\myAccessFile.mdb;.
Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=\server\share\folder\myAccessFile.mdb;
I cannot establish the connection between Azure Data Factory and MS Access Database through Linked Service.
It shows the below error when I am trying to create the linked service
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
If anyone knows how to resolve the issue and create the linked service in Azure Data Factory. Please Let me know.