SAP xi/pi连接access数据库

In case you are facing issue connecting MS Access with SAP PI, this document might be useful to you. This provides a step by step approach to resolve "driver not found" issue and specially written for PI users using Windows 7 (64 bits system). But for others also, this may have some information which will guide to reach to the actual root cause.

Below is the error message:

 

Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. sun.jdbc.odbc.JdbcOdbcDriver returns: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. : SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

 

 

First thought came to our mind when we started connecting SAP PI with MS Access, that we don’t need any driver installation as our operating system was windows and it bundles ODBC driver along with it. But, when I configured my communication channel(CC), I realized that my CC was not able to identify registered driver and some driver had to be installed. To verify it I checked my odbc administrator from Control panelà administrative tools-à ODBC and under driver tab I could see only two sql driver. So it made it clear that driver is missing.