Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 17, 2011 at 10:53 AM

    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-f2ac1399242f?quicklink=index&overridelayout=true

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 17, 2011 at 11:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded