SAP xi/pi连接access数据库

最新推荐文章于 2023-03-20 17:17:27 发布

原创

最新推荐文章于 2023-03-20 17:17:27 发布 · 2.8k 阅读

1 ·

CC 4.0 BY-SA版权

本文档详细介绍了如何解决SAP Process Integration（PI）在尝试连接到MS Access时遇到的“找不到驱动”问题，特别是针对Windows 7 64位系统的用户。错误信息涉及ODBC驱动程序未找到。解决方案包括检查OS版本、JDK版本、ODBC驱动程序位置，并提供了解决连接字符串问题的步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.