I need to connect UiPath directly to a MySQL database without using an ODBC driver. Can someone please guide me through the steps or the correct workflow needed to achieve this?
In the connection wizard select .net provided and then give the server details
cheers
1 Like
To connect UiPath to a MySQL database without using ODBC, first install the MySQL Connector/NET so UiPath can communicate through ADO.NET. In UiPath, install the UiPath.Database.Activities package, then use the Connect activity and enter a connection string such as Server=yourServerIP;Port=3306;Database=yourDB;Uid=yourUser;Pwd=yourPassword;SslMode=none; and set the ProviderName as MySql.Data.MySqlClient. After this, you can use Execute Query to read data and Execute Non Query for insert, update or delete actions using the same connection. This method allows UiPath to connect directly via ADO.NET without the need for an ODBC driver.
1 Like
Check here.
You should simply define the DSN, UID and PWD:
“Dsn=”+str_SQL_DSN+“;uid=” + str_SQL_Username + “;pwd=” + str_SQL_Password
Check if you have this.
2 Likes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.