Prev
Next
Forums Integration / Customization IPA/ProcessFlow

JDBC MS Access from IPA

 1 Replies
 2 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Karen Sheridan
Veteran Member
Posts: 142
Veteran Member
12/6/2021 4:17 PM

     

    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
    12/6/2021 4:28 PM
      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