Question

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


Badge +1

AA_mysqlError_2AA_mysqlError


7 replies

Userlevel 5
Badge +11

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>

 

 

Badge +1

thanks but tried with the same and getting a different errorAA_mysqlError_3

Userlevel 3
Badge +6

@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

Badge +1

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

Userlevel 4
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

Badge +2

How was this issue resolved. I am facing the same issue for connecting the Oracle DB. Any pointers will help greatly.

Userlevel 5
Badge +10

@RaymondJGibson 

Procedure to connect to an Oracle Database.

Instructions

  1. Check which driver required from driver matrix.

https://docs.oracle.com/en/database/oracle/oracle-database/21/jjdbc/introducing-JDBC.html#GUID-696E8F49-4B61-4520-8557-318320CE7A66

 

2021-02-23 17_38_49-Getting Started.png

 

  1. Download the driver.

https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

  1. Then add the jdbc connection string.

https://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html

Additional Information

https://www.codejava.net/java-se/jdbc/connect-to-oracle-database-via-jdbc
https://docs.oracle.com/en/database/oracle/oracle-database/21/jjdbc/JDBC-getting-started.html#GUID-00FE03D7-48D6-4DA5-A3A0-8768D2936AB8

Reply