Hi, I 'd like to use ucanaccess driver but unsuccessfully for now.
Latest Jasper Studio release : 6.6.0
I created a data adapter, set the JDBC Driver (net.ucanaccess.jdbc.UcanaccessDriver), set the JDBC Url (jdbc:ucanaccess://C:\\tmp\\DB.accdb;memory=false) and added the path to ucanaccess-4.0.4.jar in the 'Driver Classpath' tab.
Each time I try to test the connection I get a sandglass...
As you can see I tried creating a simple Access db with 1 table in the 'tmp' directory. What esle can I try ?
ps : I use Talend and it is ok but a tAccess component use different libraries to connect and not only ucanaccess (jackcess, jackcess-encrypt, bcproc...).
Thank you Hosawa !
I thought the ucanaccess library was a package of needed ones, but it is not.
I took talend as an example and added 8 jars in Jasper Studio and JRS and everything ok now :