Jump to content
Changes to the Jaspersoft community edition download ×

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


yann22580

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...