How to connect my flowchart to Mysql database?

How to connect my flowchart to Mysql database?

1 Like

"


My connection string is

“Server=localhost;port=3306;Uid=root;Pwd=root;Database=db”;

but when i running i get this exception

Did you try caps P
https://www.connectionstrings.com/mysql/

Main.xaml (23.1 KB)

yes i try all the combination but still getting error

is there any driver required for connectivity ?

i attach my xaml file here

1 Like

Hi

You can use connect to MYSQL database using UIPath, by installing Mysql-ODBC connector of 32-bit(x86) and creating a system/user DSN.

I have tried and it is working fine.

Please revert for any clarifications.

2 Likes

Rajat,

I am getting issue after installing odbc connector

Hi @thakurashish55525

Please elaborate, and if you can post the exact issue that would be great.

Regards

Rajat

Thanks for asking.

I have MySQL installed on my local machine as well as UiPath on the same
machine.
I have also installed MySQL connector, while testing ODBC connection using
connector , i am able to access my database.
But while doing the same in UiPath then getting error, i am not sure it i
am using correct option.
Below is the error i am getting at last point.

Hi @thakurashish55525

Apologies for the delay in response, but this may be helpful for some facing the same issue.

The issue as mentioned, has a mismatch of architecture between the driver and UiPath application as it seems you have installed the 64-bit version of the driver whereas, UiPath is compatible with the 32 bit version(x86).

I have listed the links for the explanation regarding the same on Technet and also the link to download the mysql - 32 bit:

  1. Technet: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/702f0d9b-6cb9-49cf-9953-80d059711e60/the-specified-dsn-contains-an-architecture-mismatch-between-the-driver-and-application?forum=sqlgetstarted

  2. Mysql 32-bit: https://dev.mysql.com/downloads/file/?id=406107

Regards

Rajat

1 Like

How to extract data from MySql database to CSV?

Hi @Snehal1

Once you are connected to the Database, you can use Mysql Execute Query and fetch the data from the database, for example in the provided snapshot, I use select query using execute query activity and the output is stored in the datatable, which is stored in a csv file using Write CSV activity.

Please revert for clarifications.

Regards

Rajat

2 Likes

Thank you @rajat.pandey :slightly_smiling_face:

Hi @rajat.pandey,how to store data scraping data directly from web to database.
Thanks in advance.

Mysql Workbench 8.0 CE is working fine.
But when i use connect activity, drop down for service name is empty even if i refresh. Please help me out.

im using SSMS and i have to write down the server name by myself.

@Made_puspa_Wedanthi for ssms you don’t need to write server name it displays automatically.

is it okay if i wrote it manually in the Server Name: (UIPath) ???

@Made_puspa_Wedanthi that’s fine once you given the details click on test connection if it says conection that’s fine you can move forward,what I’m saying is usually it shows the server name,nothing more than that.

alright thank youuu

1 Like