Skip to Content

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

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.e. MS ACCESS>SAP PI7.0>SAP

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

sun.jdbc.odbc.JdbcOdbcDriver

Connection

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=
xxxxxxx\Latest\WrkGrp_0000\Aur_card.mdb

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': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: 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

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