But what to do when it is not showing the server name in the drop down
Reply for me please
you need to use odbc 32 bit to connect uipath with mysql workbench you cannot connect directly
Hi @Nanda_RPA,
Please download MySql ODBC Driver 8.0.16 and install the driver. After that download UiPath.Database package from manage packages in UiPath. After this use âConnect Activityâ.If you have any problem regarding this or in the further steps you can ask me
Did you installed a 32 bit or 64 bit MySql Driver. You should install mysql driver of 32 bit and after installing the driver. Create a datasource in the above mentioned screen and then in the connect activity click on the ââ and from the next dropdown select â.Net Framework Data Provider for ODBCâ. After you click on OK in the next dialog box you will get the name of your datasource.
I have installed MySQL 32 bit and created data source named MySql. But still its not working, What should i do now? please help me out
@Nanda_RPA If you created the datasource in 32 bit, so now use connect activity in Uipath(If you are not getting the connect activity then you have to install the package UiPath.Database.Activities). In connect activity click on configure connection and after that connection wizard. Select Others from the first dropdown and â.NET framework data provider for ODBCâ from the second dropdown and click on OK. From the datasource dropdown select your datasource name and below provide the username and password of your database and click on âTest Connectionâ and if shows as successful then click on OK. And create a variable of type (UiPath.Database.DatabaseConnection) and assign the variable on properties pane to DatabaseConnection field. After this your database is connected.
If you need further help please let me know.
Iâm also have the same issue, if youâre using 64 bit MySQL, then none of these solutions may solve your problem.
I solved by installing MariaDB (MySQL inside XAMPP)
- Start MySQL
- Enter ODBC Data source Administrator and Add DSN with ODBC with connection credentials
- Select that DSN in UiPath DB Connection and Test Connection
Connection will be Successful for sureâŚ
Hi @rajat.pandey,
I have installed the ODBC connector. What I have to do next. Can you share the steps.
Thanks,
Sayali
It works for me. Thank you for the information