Start a new topic

Cannot connect to MS Access using UCanAccess

Hello,


I'm using DbVisualizer Free 11.0 [Build #3077]
OS: Windows 10
OS Arch: amd64
Java Version: 1.8.0_242
Java VM: OpenJDK 64-Bit Server VM


Trying to create UCanAccess driver using the following theme:

http://confluence.dbvis.com/display/UG92/JDBC-ODBC+Bridge+Driver+Alternatives

But the versions are different and now my Driver Manager looks like this:

image


Seems to be, it's ok, but when I try to connect I see the following message:

image


Where I'm wrong? Quotes in Path? Jars versions? Jars should be placed in defined place?

Thanks a lot.


1 Comment

I used the UCanAccess driver once a couple of years ago and I seem to recall having a lot of trouble getting it working with DbVisualizer as well. What worked for me is NOT to use the UcanaccessDriver. Instead I used the UcanloadDriver class which is in a JAR file called "ucanload.jar" located in the "loader" directory (see screenshot). It looks like this class will take care of resolving dependencies for the driver. The weird thing is it's not documented anywhere on the UCanAccess driver web site, as far as I can tell.

image

 

Login or Signup to post a comment