Skip to Content
0
Nov 05, 2019 at 11:21 PM

SAP PO 7.5 - JDBC driver to connect with MS Access

313 Views Last edit Nov 05, 2019 at 11:23 PM 2 rev

Hello,

I trying to connect MS Access DB file stored on PO server but, it is throwing an error

JDBC message processing failed; reason Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish a connection with the registered driver. sun.jdbc.odbc.JdbcOdbcDriver returns: sun.jdbc.odbc.JdbcOdbcDriver.
: SAPClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver

As per many blogs, we don't require any driver to be deployed in the SAP PO to connect MS access DB.

SAP PO 7.5 runs on Java 8. but, as per Oracle website

https://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html

from Java 8 onwards JDBC-ODBC Bridge is obsolete now thus, we cannot able to use the JDBC driver sun.jdbc.odbc.JdbcOdbcDriver

Does anyone faced this issue and how did you resolve it?

I appreciate your answer.