B4J Question JRDC2 Connection to Acccess "ucanaccess library"

[FreddyBlazquez]

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

 

[Erel]

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.

 

[FreddyBlazquez]

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

 

[Erel]

Try this in a new project: https://www.b4x.com/android/forum/threads/opening-ms-access-databases-mdb.107963/
Does it work?