Skip to main content
Nintex Community Menu Bar

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.




 


Be the first to reply!

Reply