MS Access linked service

Question

Hello,

I am trying to create MS Access Database Linked Service in Azure Data Factory.

I used this for creating the linked services

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\server\myAccessFile.mdb but I cannot establish the connection between Azure Data Factory and MS Access Database through Linked Service.

I am getting this error:ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

I have gone through mulitple formuns, but it didn't help. Please let me know if there is any solution.

Answer 1

Thank you @Samy Abdul
<In addition to Samy's answer>

Hi @897456 ,

I don't see your connection string information in your question. I am guessing you are using the wrong connection string.

Please check if you are using the correct information in the connection string.

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

If you still see issues, please try using the local path.

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

Also, please check your access driver.

And let us know if you still have any further questions.

------------------------------

• Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

Hi @897456 , please go through below link : Thanks

https://learn.microsoft.com/en-us/answers/questions/227987/34error-im002-microsoftodbc-driver-manager-data-so.html