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.