Skip to main content

Hi folks,

I am getting below error when I am using connection mode as “ user defined”, database type as “MYSQL”, server name as “local host”, database name as “rpa” , credentials using which are created in credentials vault, port number as “3306”

 

I am getting below error when I am using connection mode as “default” and connection is as follows:

Driver={MySQL ODBC 5.2 ANSI Driver};Server=local host;Port=3306;Database=rpa;User=$username$;Password=$password$;Option=3

here, I am selecting the check box for “Use ODBC 64-bit driver for connection”

 

Also i am not finding my sql realted option in odbc system DSN.

Kindly help me out from this issue and please let me know what are the prerequisites to connect with MYSQL database?

 

Hi @polugopi,

Please install the MYSQL jdbc driver. 

https://dbschema.com/jdbc-driver/mysql.html

Hi @polugopi,

Please install the MYSQL jdbc driver. 

https://dbschema.com/jdbc-driver/mysql.html

Hallo ​@Tamil Arasu10 ,

which version of driver and install where?

greetings

Local machine/ where the bot agent installed machine. In the link you can find the installation guide as well.

 

Hi,

Make sure the MySQL ODBC 64-bit driver is installed and correctly configured in the ODBC Data Source Administrator. If it's not listed in the System DSN tab, you can download it from the MySQL website: MySQL ODBC Driver.

Also, verify your MySQL service is running and that the credentials are correct. This should fix the issue

​@MichalTurek if any of these suggestions helped you out, could you mark them as best answer?

Hi,
Install MySQL ODBC Driver from MySQL :: Download Connector/ODBC
Also, you can check your connection string from SQL Server connection strings - ConnectionStrings.com

Reply


Terms & ConditionsCookie settings