Scripts and Java and MS Access
I have an overnight script that imports data from an MS Access query into a list, this worked fine with the old certs and the 1-3-3-3 environment. Now I have had to update my scripts and use 1.4.2 and there seems to be a problem with the url.
-jdbcurl "jdbc:odbc:EPOS" -jdbcquery "SELECT * FROM qry_EPOSLive"
-jdbcurl has been dropped as a valid option in a script, and therefore I have to create a properties file, which I have done.
Properties file top line now reads
jdbc.connect.url = jdbc:odbc:EPOS
However, when I run the script I am getting the following error
Anaplan API: Could not connect to database! (SQL: No suitable driver found for jdbc:odbc:EPOS)
What do I need to do to correct this, as we run this script every night and it is vital to our data set.