Skip to Content
Former Member
Oct 21, 2008 at 09:22 AM

JDBC Sender for MS Access (how to?)


Hi experts,

I would like to read a MS Access DB allocated in an external server, but I am still a bit confused after reading many threads and blogs about this issue.

Most of the people says no driver installation is needed when PI is running on Windows (my case).

I also use to see the following configuration of the CC connecting parameters:

JDBC Driver: jdbc.odbc.JdbcOdbcDriver

Connection: jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=//xiserver*/xitemp/db/TestDB.mdb;Uid=yourid;Pwd=yourpwd;

Does it mean it is mandatory the DB file to be in the PI server or is this only for test's purpose? How to update the DB then?

Is it possible to connect to an Access DB in a server different from the PI server as well? i.e. ...DBQ=//<server IP>/path

Many thanks in advance,