Error in Query Execution using Mysql Database

“Server=127.0.0.1;port=3306;database=name_db;uid=root;password=;”

Error:-
21.10.3+Branch.master.Sha.8291b2799a85589c5b075e0d1f69016fc83eec97

Source: Execute Query

Message: Value cannot be null.
Parameter name: At least one of the connections must be used.

Exception Type: System.ArgumentNullException

RemoteException wrapping System.ArgumentNullException: Value cannot be null.
Parameter name: At least one of the connections must be used.
at UiPath.Database.Activities.ExecuteQuery.d__43.MoveNext()
— End of stack trace from previous location where exception was thrown —
at UiPath.Database.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

Hi @Roshan_Ouseppachan ,

Since we cannot connect Mysql DB directly in our Uipath. Could you check the below steps already configured in your machine. thanks.

  1. Install MySQL ODBC Driver
  2. Create system/user DSN
  3. Use the option ODBC DATA SOURCE for creating the connection
  4. In the next window, select the DSN created above under system/user Data Source Name
1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.