Connect MySql Database - Myql.Data.MySqlClient provider does not exist

[Italo_Cosendey (Ítalo Cosendey)]

Hello everyone, everything good?
I’m having problems here with the platform when it comes to making a connection with an external MySql database. It turns out that I can’t find the Provider MySql.Data.MySqlClient. The problem happened after updating to the new version of UiPath 2023.12 on the Windows version (the legacy continues to appear). The MySql Connector is fine, even working in other applications. Can anyone help me?

[pikorpa (Piotr Kołakowski)]

Hey @Italo_Cosendey
Please check this topic.
Hope it helps.

MySQL Provider isn't available in database connect activity

HI @Tiago_Martin Indeed the MySQLClient is missing. After discussions with UiPath support, a workaround is to use a configuration in ‘ODBC Data Source Administrator’ (install it if you don’t have it). Under System DSN, you need to click 'Add…: [image] Choose MySQL … ANSI: [image] Fill correctly the information and click ‘Test’, it should make a connection: [image] If the connection is successfully made, click Ok and return in UiPath. Open the wizard and you should see under ODBC data s…

[marian.platonov]

A Windows compatibility project that has activities with the MySql.Data.MySqlClient connection throws an error unless the connection option is set to System.Data.Odbc (the MySQL ODBC Driver needs to be installed on the machine using the Microsoft ODBC Data Source Administrator).

Reference: Activities - Release Notes

Fow Windows compatibility projects, you need to install an ODBC 64-bit driver and use an User or System DSN configured in Start → ODBC Data Sources (64-bit) in the Studio/Robot machine.

After, you can configure the connection in the Connect to database activity in Studio.

[Italo_Cosendey (Ítalo Cosendey)]

My solution to solve the problem was to configure click to configure with Wizard and I selected it as follows, as shown in the print below. Just below I selected MySql and made the connection. It worked!