Solved

AS400 Driver is Not Loaded

  • 21 August 2023
  • 3 replies
  • 170 views

Badge +1

I’m trying to connect to AS400, but ‘Driver is Not Loaded’ appears.

 

icon

Best answer by ravi.pothana 21 August 2023, 20:48

View original

3 replies

Userlevel 3
Badge +8

Hi @nataddib 

The Oracle database driver must be installed on the machine, as it will be managed independently from the Automation Anywhere product.

Download the driver jar file from official website: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html 

Once you have jar file downloaded, select BOTS → My bots → Click Upload files to select the .jar file and add files to upload. 

you can follow the instructions in below article which is similar to your use case. 
https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/connect-to-a-micro-sql-serv-wi-win-auth.html
Note: If you are on Build 9664 or later, you do not have to copy the file to the location in which Bot Agent was installed.

 

Thank you. 

 

Badge +1

Hi @ravi.pothana 

 

So I cannot use jt400.jar to connect to AS400? Is it that AA does not support AS400 JDBC driver class?

 

Thank you.

Userlevel 3
Badge +8

Hi @nataddib 

here is the list of databases supported in Automation 360 and their JDBC and ODBC connectivity.
https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/database-engine-support-matrix.html

 

Reply