Hello,
I am facing this error.
Error: Connect to database: The specified invariant name ‘MySql.Data.MySqlClient’ wasn’t found in the list of registered .NET Data Providers.
Hello @Aastha_Singh
Check your workflow, otherwise made a connection by using the connection wizard property.
Refer to this thread, you may get some idea
There could be two issues as :
1.
The above issue means that your connection string format is not correct.
Below is the correct format:
if using MS SQL Server : “Data Source=ServerNameValue;Initial Catalog=DatabaseNameValue;User ID=UserNameValue;Password=PasswordValue;Encrypt=False”
and ProviderName should be : System.Data.SqlClient
If using MYSQL : Server=ServerNameValue;Port=PortNoValue;Database=DatabaseNameValue;Uid=UserNameValue;Pwd=PasswordValue; and ProviderName should be :
MySql.Data.MySqlClient
Other issue could be if you are using latest version of UiPath Studio like 22.10.3 then while creating new Process make sure you use Compatibility as Windows Legacy(based on .NET Framework 4.6.1) and not the Windows (based on .NET Framework 6.0)
2 Likes
yeah, but Windows Legacy will be phased out. so another solution has to be found
or we need to wait that they update the package activities to be compatible with .net 6
@uipath when would that be planned?
We fixed this issue by downgrading the UiPath.Database.Activites package to version 1.6.1.
1 Like
hi all,
the issue should be solved now.
The package has been updated and is compatible with .net 5