Connection String for MySQL database

Help
,
1

Hi all,

I am new to RPA. I want to Connect a MySQL database for my UIPath Project. When I create a Connection String, It Shows this error.
My Connection String is : "Server=localhost; Uid=root; Pwd= ; Database=save_pdf_data”

image
image1214×525 31.8 KB

Can Anyone Help me on this :roll_eyes:

2

Hi Savithrin,

You need to configure connection string with MySQL ODBC driver.
using Connect activity–>click Configure–>select Other–> from below dropdown select “.Net Framework dataprovider for ODBC”–>Ok
In the connection properties, select “use Connection string”–>Build.
On select Datasource, click on Machine datasource, where you should find your MySQL Datasource driver.If you dont find one, Click on new and follow guided steps to create one. You can follow below documentation for that.
https://dev.mysql.com/doc/visual-studio/en/visual-studio-making-a-connection.html
once back at select datasource page, input username and password and test connection and you are done!!!

4 Likes
3

I’ve used the following string to connect to MySQL Database:
“Server=localhost;Port=3306;User=enterUser;Password=enterPassword;Database=enterDatabaseName”

4

Hi @Mariliza_Bonesso what provider name you are using for this connection string?