1. *** New version of B4J is available ***
    B4J v7.8
    Dismiss Notice

B4J Question JRDC2 Connection to Acccess "ucanaccess library"

Discussion in 'B4J Questions' started by FreddyBlazquez, Aug 8, 2019.

  1. FreddyBlazquez

    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
     

    Attached Files:

  2. Erel

    Erel Administrator 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.
     
    OliverA likes this.
  3. FreddyBlazquez

    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
     
  4. Erel

    Erel Administrator Staff Member Licensed User

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice