Page 1 of 1

Connect to MySQL on phpMyadmin

PostPosted: Wed Oct 02, 2019 2:29 pm
by torbrjp
Hello,

I want to execute a RoboTask SQL Query on a MySQL server that is in phpMyadmin. How can I connect to the MySQL server using either the Data Link File or Connection String?

Re: Connect to MySQL on phpMyadmin

PostPosted: Thu Oct 03, 2019 10:04 am
by Oleg
Just install MySQL ODBC connector for windows 32-bit
Next - configure user or system DSN in ODBC data source administrator Now you can execute SQL expressions directly from RoboTask on MySQL database.

Please note that RoboTask is 32-bit application. So it uses 32-bit ODBC DSN.
you can find ODBC data source administrator 32-bit here: C:\Windows\SysWOW64\odbcad32.exe

Re: Connect to MySQL on phpMyadmin

PostPosted: Thu Oct 03, 2019 10:16 am
by Oleg
Also look here how you can create the connection string: viewtopic.php?f=1&t=1592&p=4832#p4832