Question

Unable to connect with MySql database. Tried multiple ways but getting various errors

  • 6 July 2022
  • 5 replies
  • 24 views

AA_mysqlError_2AA_mysqlError


5 replies

Userlevel 3
Badge +7

Hi @Angsuman Ganguly​ ,

 

To access any database through ODBC, you must first install a 32-bit ODBC driver on your device.

 

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-using-database-connect-action.html/p>

 

https://docs.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver16/p>

 

 

thanks but tried with the same and getting a different errorAA_mysqlError_3

Badge +4

@Angsuman Ganguly​ 

Download and install mysql odbc drivers: 32 bit version

https://dev.mysql.com/downloads/connector/odbc/

Use connection string and replace with your corresponding values(server-address,dbname,username,password):

 

DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=server-address;DATABASE=dbname;USER=username;PASSWORD=password;OPTION=3;

 

 

image

Tried but getting same error. Username and password can be random ? I tried Mysql password but didn't helpAA_mysqlError_4

Userlevel 3
Badge +7

Hi @Angsuman Ganguly​ ,

 

Could you try following the steps detailed in this tutorial and see if that works out for you?

 

Kind Regards,

Ashwin A.K

Reply