DivyaT
(Divya)
September 20, 2019, 7:54am
1
Hi ,Am unable to connect client mysql server through uipath but its not connecting please help me out in this.I tried by giving connection string also not accepting,continously getting error.I can connect in mysql application but i would like to access directly and this server only works under VPN.
strqsr
(strqsr)
September 20, 2019, 8:13am
2
Have you tried these methods?
1 - very first you have to check version of MySQL server.
2- You have to download and install the mysql connector according to the version and how many bit (32bit/64bit) set of my sql u have install.
3- then you have to create odbc connection string into your system. for that follow below step
Open control panel then go to Administrative Tools then select ODBC data source Administrator according to setup u have install it is better if you install 32 bit.
In ODBC data source Administrato…
1 Like
Natapong
(Natapong Raojutitam)
September 20, 2019, 8:14am
3
You can use Database activity to connect to mysql.
*Need to add ODBC Data source for mysql first.
Please refer at below
Hi @Snehal1
Once you are connected to the Database, you can use Mysql Execute Query and fetch the data from the database, for example in the provided snapshot, I use select query using execute query activity and the output is stored in the datatable, which is stored in a csv file using Write CSV activity.
[image]
Please revert for clarifications.
Regards
Rajat
strqsr
(strqsr)
September 20, 2019, 8:15am
4
Yes I know, the link i gave for the first showed that
DivyaT
(Divya)
September 20, 2019, 8:22am
5
I can easily connect mysql server thruogh uipath only if i have it in my machine through odbc connector but the thing is i wants to connect/access directly from other system means client mysql server .
strqsr
(strqsr)
September 20, 2019, 1:32pm
6
Do you mean a remote server?
DivyaT
(Divya)
September 23, 2019, 12:59pm
7
remote server means connecting client server
DivyaT
(Divya)
September 23, 2019, 1:00pm
8
Thanks for your response i found solution based on your explanation.
strqsr
(strqsr)
September 23, 2019, 3:35pm
9
Oh which one helped you out? Mind marking it as a solution so others who face the same will know as well!