The SQL connection object is failing with error message "U02012064 No driver found"

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The target DB is called Denodo and the connection string used in the connection object is as shown below.


When you click on Test button of the connection object, the error message is shown below.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

For this particular case, the string in the connection string is incorrect. The string vdp should be vbd.

Incorrect: 
jdbc:vdp://<hostname of the denodo>:<port of Denodo>/btatest

Correct:
jdbc:vdb://<hostname of the denodo>:<port of Denodo>/btatest

Resolution

Please modify the connection string from jdbc:vdp://<hostname of Denodo>:<port of Denodo>/btatest  to jdbc:vdb://<hostname of Denodo>:<port of Denodo>/btatest 

Another possible solution is to make sure that jdbc driver of the Denodo database is present in the <DB Service agent>\bin\jdbc.