How to use UcanAccess library in Jasper Studio to connect to MS Access ?
Posted on January 18, 2019 at 2:58am
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
Joined: Apr 29 2015 - 1:10am
Last seen: 10 months 3 weeks ago
Posted on January 19, 2019 at 11:01pm
Have you added all the files under the lib to the classpath? Set it up and tested the connection and got "Successful".
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 3 months ago
Posted on January 21, 2019 at 2:49am
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
Joined: Apr 29 2015 - 1:10am
Last seen: 10 months 3 weeks ago
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