Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Access to MS Access DB using JDBC adapter

Hi experts,

PI 7.1 (AIX) needs to access to a MS Access DB. For this purpose, we will use the JDBC adapter but we wanted to know:

1) do we need to install any driver in PI server?

2) do we need to install anything in the target server (where the DB resides)?

3) I think that connection parameters should be something like:

- JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver

- Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//<target_IP>/<path>file.mdb

Is that correct? what about the port?

Hope you may help me out on this...

Thanks in advance and best regards,

David

Former Member
Not what you were looking for? View more on this topic or Ask a question