B4J Question JRDC2 Connection to Acccess "ucanaccess library"


New Member
Licensed User
Hi everyone

I´m not getting to connect to accdb file (Acccess BD)). I´ve downloaded UCanAccess Java JDBC Driver for Access from http://ucanaccess.sourceforge.net/site.html. I´ve put this jar files: ucanaccess-4.0.4,, hsqldb, jackcess-2.1.11, commons-logging-1.1.3, commons-lang-2.6 in C:\Program Files (x86)\Anywhere Software\B4J\Additional Libraries (also they are in \Libraries). In JRDC server I have like something new:

#AdditionalJar: ucanaccess-4.0.4
#AdditionalJar: hsqldb
#AdditionalJar: jackcess-2.1.11
#AdditionalJar: commons-logging-1.1.3
#AdditionalJar: commons-lang-2.6

The rest of code is the same

In the ConfigProperties file I´ve:

When I do "http://localhost:17188/test" on the navigator I get:
RemoteServer is running (08/08/2019 11:09:47)
Error fetching connection.

Really I want to connect to Remote Windows Server (with Access) and then I´ve tried also:

For both cases the error is the same

I think so that the server is correct but I don´t write properly the JdbcURL

Please, How I have to write jdbcURL properly to get a remote connection?
Have I do anything on windows server?




Staff member
Licensed User
Where is the access file? On the same computer that jRDC2 is running on? It should be.

BTW, don't use MS Access DB unless you must.


New Member
Licensed User
Yes, for the first test, on my own computer, the JRDC2 was running on the same machine that the access file with this in ConfigProperties:

In the case of the remote connection it wasn´t, the JRDC and the acccess file were iin differents machines, but it would not a problem.

Unfortunately I don´t have any choice. I must use an access file. Another way is not possible for the moment. I don´t like access neither