How to connect my flowchart to Mysql database?

Help
,
1

How to connect my flowchart to Mysql database?

2
1 Like
3

"

pd.png1920Ă—1080 129 KB

My connection string is

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

but when i running i get this exception

4

Did you try caps P

5

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
6

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
7

Rajat,

I am getting issue after installing odbc connector

8

Hi @thakurashish55525

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

Regards

Rajat

9

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.

image.png942Ă—725 24.8 KB

10

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: The specified DSN contains an architecture mismatch between the Driver and Application

  2. Mysql 32-bit: MySQL :: Begin Your Download

Regards

Rajat

1 Like
11

How to extract data from MySql database to CSV?

12

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.

image
image1920Ă—1080 459 KB

Please revert for clarifications.

Regards

Rajat

2 Likes
13

Thank you @rajat.pandey :slightly_smiling_face:

14

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

15

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.

Connect%20Activity
Connect%20Activity1366Ă—768 147 KB

16

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

17

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

18

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

19

@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.

20

alright thank youuu

1 Like