Unable to Connect MySQL with UIPath

[anand.t]

Hi All,

I installed the MySQL connector but unable to find driver on ODBC.

Please help what I am doing wrong.

Regards
AN

[Achiranga (Achiranga Gunasekara)]

in your connection wizard select the “System.Data.Odbc”

[anand.t]

YES.

[anand.t]

When trying to connect with ODBC

[Achiranga (Achiranga Gunasekara)]

connection string
“Dsn=;uid=;pwd=”

your data source name- RPA as per the screenshot
username -RPA

[anand.t]

This is my connection string…

“server=‘xx.xx.xx.xx’; DSN=‘ABC’;UID=‘RPA’; PASSWORD=‘*********’; DATABASE=‘Report’; PORT=‘3306’;”

Getting this error while compiling…

“message”: “Connect: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified”

[Achiranga (Achiranga Gunasekara)]

thats your odbc connection string .

in UiPath add following connection string and replace the password and give a try.
“Dsn=(RPA);uid=(RPA);pwd=(*password)”

[anand.t]

Not working…
“server=xx.xx.xx.xx;Dsn=ABC;Uid=RPA;pwd=*********;DATABASE=Report;PORT=3306”

Can you please send a sample connection string for UiPath?

Thanks

[Achiranga (Achiranga Gunasekara)]

in_envirnment = RPA ( this is the user data source name you given when your creating the connaction in ODBC )
in_Username= RPA

[SorenB]

Hello @anand.t

You should simply define the DSN, UID and PWD:

"Dsn="+str_SQL_DSN+";uid=" + str_SQL_Username + ";pwd=" + str_SQL_Password

Regards
Soren

[anand.t]

Hi @Achiranga

Please tell me what version of database activity you are using. I am unable to get per your screenshots. The below I am using.

[loginerror (Maciej Kuźmicz)]

If this is a Windows type project, then it requires the 64bit drivers to work I believe. You might be able to verify this by trying what you’ve already tried, but on a legacy project.

Otherwise you’ll have to install the 64bit drivers.

[anand.t]

Its working thanks