Getting error while connecting to the database

Help
, ,
22

Hi Palani, Now I have the database but I am getting the same error.
kindly help @Lahiru.Fernando @Palaniyappan

1 Like
23

Can I have the screenshot of it if possible
cheers @balkishan

1 Like
24

1. Install the MySQL ODBC Driver:

2. Create a MySQL ODBC Data Source (DSN):

  • Go to Control Panel → Administrative Tools → ODBC Data Sources (64-bit).
  • Under System DSN, click Add.
  • Choose MySQL ODBC 8.x Unicode Driver (or whatever version you installed).
  • Fill out:
    • Data Source Name: e.g., my_xampp_db
    • TCP/IP Server: localhost
    • User: root
    • Password: (leave empty if no MySQL password)
    • Database: choose email_db or whatever your DB is
  • Click Test to ensure it connects.
  • Click OK to save.

3. In UiPath Database Connect Activity:

  • Choose:
    • Data source: Microsoft ODBC Data Source
    • Data provider: .NET Framework Data Provider for ODBC
  • Select User or System Data Source Name → pick my_xampp_db
  • Test the connection.

I was facing same problem but got this solution and its working.

25

Update DB package to latest.