Connect to MySQL on phpMyadmin

Discuss RoboTask here

Connect to MySQL on phpMyadmin

Postby torbrjp » Wed Oct 02, 2019 2:29 pm

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?
torbrjp
 
Posts: 2
Joined: Thu Sep 05, 2019 3:44 pm

Re: Connect to MySQL on phpMyadmin

Postby Oleg » Thu Oct 03, 2019 10:04 am

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
Oleg Yershov
Oleg
Site Admin
 
Posts: 2471
Joined: Thu Jan 01, 1970 1:00 am

Re: Connect to MySQL on phpMyadmin

Postby Oleg » Thu Oct 03, 2019 10:16 am

Also look here how you can create the connection string: viewtopic.php?f=1&t=1592&p=4832#p4832
Oleg Yershov
Oleg
Site Admin
 
Posts: 2471
Joined: Thu Jan 01, 1970 1:00 am


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 17 guests