How to use UcanAccess library in Jasper Studio to connect to MS Access ?

[yann22580]

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...).

Regards,

Yann

[hozawa]

Have you added all the files under the lib to the classpath? Set it up and tested the connection and got "Successful".

[yann22580]

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  :

ucanaccess-4.0.4.jar

commons-lang-2.6.jar

commons-logging-1.1.3.jar

hsqldb-6.0.0.jar

jackess-2.2.2.jar

bcprov-jdk15on-1.60.jar

jackess-encrypt-2.1.4.jar

talnd-ucanaccess-utils-1.0.0-6.4.0.jar

Regards,

Yann