Connect to MySQL database error

[mavsp8 (mavs)]

For MySQL

I am trying to insert data from Datatable to MySQL database.

I have used connection string to connect my database:

“server=localhost;uid=root;password=ui123;database=sampledb”

the output I am getting is as shown below:

want to know what can I do to solve this error?

Thank You.

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi @mavsp8 ,

To connect my sql db from UiPath we have to download my sql driver from internet and use ODBC connector to connect with UiPath. Please refer the below link which is having step by step process to connect the mysql DB with 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…