Integrate PI7.0 with MS Access 2003 Database

[Former Member]

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]

Hello,

There is information on how to install the drivers in the XI Configuration Guide for 3.0/7.0:

service.sap.com/instguidesnw04 -> Installation -> SAP XI

You may get the answer from Note 831162 -

1. JDBC Driver Deployment

13. JDBC Drivers

You may need to consult the DBMS Vendor about what driver jars they offer for a specific release. Then you can refer to section-

"11.1 External Drivers for the JDBC and JMS Adapters" in Configuration Guide.

Regards,

Sarah

[Former Member]

Hello Mr Patil,

You need to install Jdbc Microsoft Access Driver.

You need to get Jdbc MS Access Driver

Then, install driver in PI Administration. You can follow this link:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...