Page 1 of 1
Connect to MySQL on phpMyadmin
Posted: 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
Posted: 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
Posted: Thu Oct 03, 2019 10:16 am
by Oleg
Also look here how you can create the connection string:
https://robotask.com/forum/viewtopic.ph ... 4832#p4832