Access to MS Access DB using JDBC adapter

[Former Member]

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]

HI,

Hope this helps:

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

It should work on PI 7.1 as well.

Best Regards

Divyesh

[former_member181962]

Hope this guide gives you some information:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Regards,

Ravi

[Former Member]

Hi,

I already got this guide and used it when i had to install ojdbc14 driver in order to connect to ORACLE db. Unfortunately, it only explains how to deploy the driver but not show a full list of the drivers/DB vendors...

Could you please give some help?

Best reagards,

david

[Former Member]

Hi David,

Did you connected to MS access DB from PI successfully? Did the deployment of ojdbc14.jar helped?

If yes please share me the JDBC driver and connection parameters, I have an urgent requirement..