JDBC MS Access from IPA

Sort:
You are not authorized to post a reply.
Author
Messages
Karen Sheridan
Veteran Member
Posts: 141
Veteran Member

     

    Is it possible to set-up a JDBC connection from an IPA?

    JDBC Driver:

    jdbc:odbcriver={Microsoft Access Driver (*.mdb, *.accdb)}

    Database URL:

    jdbc:odbc://C:\users\karen.sheridan\access\nonemployeeproject\;DatabaseName=nonemployee.accdb

    I know this won't work on the server side.  But I'm not getting pasted the driver set-up.

    Test Connection error message:

    SQL Test Connection: JDBC Driver jdbc:odbcriver={Microsoft Access Driver (*.mdb, *.accdb)} not found in classpath. Please add jdbc driver to Infor Process Server classpath.

    The jar files in the LIB\jdbc directory on my laptop:

    ojdbc7.jar, sqljdbc4.jar, db2jcc_license_cu.jar, db2jcc4.jar

    If it can be set-up, will this type of connect only work running local?

    Thanks in advance,

    Karen

     

    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
      SQL in IPA only seems to work through the server setup any longer, even though the local setup still seems available. They conflict so it might be one or the other only. If it worked locally, it would be local only.
      David Williams
      You are not authorized to post a reply.