B4J Question JRDC2 Connection to Acccess "ucanaccess library"

FreddyBlazquez

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:
DriverClass=net.ucanaccess.jdbc.UcanaccessDriver
JdbcURL=jdbc:ucanaccess://C:/A.accdb;memory=True

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:
DriverClass=net.ucanaccess.jdbc.UcanaccessDriver
JdbcURL=jdbc:ucanaccess://176.168.50.123:17188/Path1/Path2/A.accdb

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?

Thanks
 

Attachments

FreddyBlazquez

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:

DriverClass=net.ucanaccess.jdbc.UcanaccessDriver
JdbcURL=jdbc:ucanaccess://C:/A.accdb;memory=True
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
 
Top