Connection String for Ms Access in ADF Linked Service

Question

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.

Answer 1

Hello @Hemanath Goud Kandula ,

Welcome to the MS Q&A platform.

I believe you are using SHIR here and I was able to test using the below connection string.

Driver={Microsoft Access Driver (.mdb, .accdb)};Dbq=\DESKTOP-name\access\Nutritiondb.accdb;

can you try using the local path?

Ex:
Driver={Microsoft Access Driver (.mdb, .accdb)};Dbq=D:\access\Nutritiondb.accdb;