on 05-17-2011 11:41 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.