A couple of options:

First, use the 32-bit JDBC driver.

Second, have you tried our User-Defined data source for MySQL?

Hallo ​@Aaron.Gleason, thanks for quick response,

1. Which driver did You have in mind? I’ve dwonloaded mine from https://downloads.mysql.com/archives/c-j/
2. Did You mean using an ODBC driver?

The user-defined connection mode has a preset for MySQL:

You may be able to use this instead of wrangling with a JDBC driver.

Following your link and searching for myself, it doesn’t appear there is a 32-bit JDBC driver for MySQL… or I haven’t found it yet. Give the user-defined mode a try and see if that works.

The user-defined connection mode has a preset for MySQL:

You may be able to use this instead of wrangling with a JDBC driver.

Following your link and searching for myself, it doesn’t appear there is a 32-bit JDBC driver for MySQL… or I haven’t found it yet. Give the user-defined mode a try and see if that works.

Hallo again ​@Aaron.Gleason , of course I\ve tried that method, it failed, not working

I’ve done some research, and hat’s what i’ve found:

DB is pretty old ver. 5.0.26 and the corresponding JDBC driver is 5.0.2 or above and is called: “com.mysql.jdbc.Driver”. The newer drivers are called “com.mysql.cj.jdbc.driver”. That’s why when using an old driver the error message is: ‘Driver is not loaded! com.mysql.cj.jdbc.Drive’, question is why the old driver cannot be used and why Automation Anywhere demands the new driver? On the other hand, when using new driver got stuck with: 'Couldn't connect to data base. CLIENT_PLUGIN_AUTH is required' since the MySQL ver is old and maybe incompatibile with the new driver?

Is there any way to make JDBC driver work with MySQL ver. 5.0.26 in AA360?

Hallo again,

I’ve managed to find a walkaround of the problem: using a MySQL ODBC 32-bit 5.3.13 driver.

The procedure is:

• Download and install MySQL ODBC 32-bit 5.3.13 driver from https://downloads.mysql.com/archives/c-odbc/,
  • in case of an error (Error 1918. Error installing ODBC driver MySQL ODBC 5.3 Driver, ODBC error 13: The setup routines for the MySQL ODBC 5.1 Driver ODBC driver could not be loaded due to system error code 126: The specified module could not be found. ...\myodbc5s.dll) or an error of missing VC++ redistributable during installation of ODBC driver, Download and install Visual c++ redistributable 2013 (x86 & x64) from https://www.microsoft.com/en-gb/download/details.aspx?id=40784,
• Having the ODBC driver properly installed, set up an DSN in system ODBC data sources (32-bit):

This DSN should be set-up on every BotRunner host.

• When establishing connection, use DEFAULT Connection Mode with a connection string:

Driver={MySQL ODBC 5.3 ANSI Driver};Server=<DB Server IP or name>;Database=<Your DB name>;User=<DB User Name>;Password=<DB User Password>;Option=3;

Hope it helps,

greetings MT