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

  • JRDC error.txt
    8.1 KB · Views: 95

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
 
Upvote 0
Top