'No suitable driver found for jdbc:OpenAccess' error when running JasperSoft reports.
'No suitable driver found for jdbc:OpenAccess' error when running JasperSoft reports.
<Please see attached file for image>
CA Service Desk Manager 14.1.03, 14.1.04 and 17.0JasperSoft 6.2 and 6.3All Supported Operating Systems
Please follow the steps from the following DOCOPS URL to edit the SDM data source in Jasper:
https://docops.ca.com/ca-service-management/14-1/en/integrating/cabi-jasperreports-server-r6-2-0-for-ca-service-management/configure-cabi-jasperreports-server-r6-2-0-for-ca-service-management#ConfigureCABIJasperReports®Serverr6.2.0forCAServiceManagement-Step3:ConfigureCABIJasperReports®Serverr6.2.0forCASDM
Specifically, the JDBC driver should be "com.ddtek.jdbc.openaccess.OpenAccessDriver"
For the URL portion of the SDM_DS JasperSoft datasource, it must be in the format of:
jdbc:openaccess://<ca_sdm_hostname>:19987;ServerDataSource=Default
Where <ca_sdm_hostname> is the host name of the server where CA SDM is installed.
Test the data source connection and save the changes.