2

I'm exhausted searching how I can connect Jaspersoft Studio to my database in Access using the Driver UcanAccess! I dont want to use OBDC anymore.

I already insert all jar files inside lib/ folder to my Classpath:

enter image description here

I tried setting the JDBC URL Like this:

jdbc:ucanaccess://C:/Users/Phillips/Documents/NetBeansProjects/SaludParaTodos/src/Hospital.accdb;showSchema=true

and this:

jdbc:ucanaccess://C:/Users/Phillips/Documents/NetBeansProjects/SaludParaTodos/src/Hospital.accdb

enter image description here

But still getting the same error!

enter image description here

it seems that the program does not find the driver but it is inexplicable because I'm pointing the Classpath! (commons-lang-2.6,commons-logging-1.1.1,hsqldb,jackcess-2.1.3)

¿How I suppose to install that driver in Jasper Studio?

Alex K
  • 22,315
  • 19
  • 108
  • 236
TwoDent
  • 405
  • 7
  • 26

1 Answers1

2

You need the dependencies from the lib/ folder, plus the UCanAccess jar itself (e.g., ucanaccess-3.0.7.jar). That's five (5) jar files in total. And yes, your connection URL should include ;showSchema=true.

Gord Thompson
  • 116,920
  • 32
  • 215
  • 418