Trying to open MDB file (MS Access) in Base 25.2.6.2 according to this tutorial:
https://wiki.documentfoundation.org/Faq/Base/How_to_connect_to_a_Microsoft_Access_database/cs
But it gives me an error in the step “JDBC driver class”, when I type “net.ucanaccess.jdbc.UcanloadDriver” there. All the steps before made successfully.
Any suggestion?
You have downloaded ucanaccess from UCanAccess-A Pure Java JDBC Driver for Access?
You have unzipped and found the file ucanaccess-5.0.1.jar, also ucanload.jar?
.
ucanload has to be added in the class path for Java.
.
In the connection for Access files for JDBC-connection should be added
jdbc:ucanaccess:///home/<path_or_alias>
(your special path to the *.mdb-file)
Driver will be net.ucanaccess.jdbc.UcanloadDriver
.
This information for the driver could be found when unzipping ucanaccess-5.0.1.jar and looking in META-INF → services → java.sql.Driver