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
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.