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

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 error

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

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

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

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

@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

2. Download the driver.

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

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