Knowledge Base

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

  • 7 December 2023
  • 0 replies
  • 46 views

Badge +1

Topic

While executing sql query for Mysql, getting error :

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


Instructions 

While building connection string using builder it shows like below:

Provider=MSDASQL.1;Persist Security Info=False;User ID=root;Data Source=MySQL8.2_64Bit;Initial Catalog=kryontest

With above you will get the error which is mentioned in subject line.

To avoid this add DSN which you defined in ODBC 64bit :
 
Provider=MSDASQL.1;Persist Security Info=False;User ID=root;DSN=MySQL8.2_64BitUnicode;Data Source=MySQL8.2_64Bit;Initial Catalog=kryontest

That's it, now you can run sql query using robot or studio.




 



0 replies

Be the first to reply!

Reply