Skip to main content
Cadet | Tier 2
March 24, 2022
Question

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

  • March 24, 2022
  • 1 reply
  • 844 views

I have an automation that connects to an excel file as a DB to retrieve data from that file. The automation runs fine on my Dev environment but when I moved it to one of our production machine I get the below error message when it enters that task.

 

Error Message : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    1 reply

    Tamil Arasu10
    Most Valuable Pathfinder
    Most Valuable Pathfinder
    March 24, 2022

    Hi @Ramya M​ 

     

    Please install the Microsoft Access engine 32 bit provided officially by MS that will help you resolve this issue

     

    https://www.microsoft.com/en-US/download/details.aspx?id=13255

     

    Thanks!

    _Tamil_