Skip to Content
Former Member
May 17, 2011 at 10:41 AM

Integrate PI7.0 with MS Access 2003 Database


Hi All,

I have an requirement to integrate SAP PI 7.0 with MS access 2003.


I have configured the sceanrio end to end.

I am using the Sender JDBC communication channel to connect to MS Access.

From SDN Blogs,It looks like Microsoft doesu2019t provide a standard JDBC driver for Access, however it seems to be possible to use the standard bridge ODBC driver to connect to MS Access from PI and there is no need for any drivers to be installed on PI separately

I have followed the SDN link (/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

)to configure the sender JDBC communication chennel to connect to MS access.

Here are the Sender JDBC Communication Channel Parameters which i have configured

JDBC Driver



jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=

And i am getting the below error

"Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=

xxxxxxx\Latest\WrkGrp_0000\Aur_card.mdb'using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': ' Cannot establish connection : : SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'

Can anyone Please tell me whether the above JDBC comm channel prameters are configured correctly and how do i resolve the above error.

And also let me know how do I know the drivers are installed on the server or not, if not how to install the JDBC drivers for ms accessin PI 7.0.

Thanks in Advance