How to connect client sql through uipath

[DivyaT (Divya)]

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]

Have you tried these methods?

How to connect to MySQL database using UiPath

Is it possible to connect to mysql database using uipath? If yes? How to connect to MySQL Database?

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…

UiPath Tutorial For Beginners | Sql Server Connection - RPA development

[Natapong (Natapong Raojutitam)]

You can use Database activity to connect to mysql.
*Need to add ODBC Data source for mysql first.

Please refer at below

How to connect my flowchart to Mysql database?

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]

Yes I know, the link i gave for the first showed that

[DivyaT (Divya)]

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]

Do you mean a remote server?

[DivyaT (Divya)]

remote server means connecting client server

[DivyaT (Divya)]

Thanks for your response i found solution based on your explanation.

[strqsr]

Oh which one helped you out? Mind marking it as a solution so others who face the same will know as well!