Connecting MySQL And Other ODBC Databases In Windows Compatibility Projects

How to connect MySQL and other ODBC Databases in Windows compatibility projects ?

Issue Description: How to connect a MySQL database after migrating from Windows legacy compatibility to Windows compatibility?

When using "System.Data.Odbc" as the provider name in a Windows project, which works in Windows-Legacy, "ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application" is returned.

Changing to "Microsoft.Data.SqlClient" in a Windows project results in "Connect to database: Keyword not supported: 'dsn' " error.


Description: The Database Activities release notes for V1.7.0 indicate, "When configuring a new database connection in Windows projects, Microsoft.Data.SqlClient is now the only SQL client option. For Windows - Legacy projects, you can choose between System.Data.SqlClient or Microsoft.Data.SqlClient." (Emphasis added.)

Resolution:

  1. Create the DB connection using version 1.7.0+ of UiPath.Database.Activities
  2. Install the 64-bit MySQL ODBC driver or similar client-specific driver
  3. Configure a system data source for the connection
  4. Set the data provider as "System.Data.Odbc" in the Execute Query activity.