Skip to Content

SAP PO 7.5 - JDBC driver to connect with MS Access

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on May 08 at 03:19 PM

    Hello,

    I know it is a late answer but for those who need to use JDBC-ODBC bridge for SAPJVM 8 I tried to explain as below.

    Check your SAP PO JVM version first.

    I am using Windows, so I will explain for Windows(took the first 5 steps from https://support.migration-center.com/hc/en-us/articles/360012716534-How-to-enable-JDBC-ODBC-bridge-for-Java-8- )

    1. Download a JDK 7 or JRE 7.
    2. Goto JRE\lib folder and find the rt.jar
    3. Unzip it (if you have 7zip installed) or you can rename it to rt.zip and unzip it.
    4. Extract the sun\jdbc and sun\security\action folders out while maintaining the same folder structure:


    5. Move the sun folder in the \bin of the Java 7 and open a CMD window. Run the command:
    jar -cvf jdbc.jar sun

    6. You will get jdbc.jar and JdbcOdbc.dll files.

    7. Copy JdbcOdbc.dll file to "\usr\sap\(SID)\SYS\exe\jvm\NTAMD64\(JVM_VERSION\)sapjvm_8\jre\bin" directory of your system.

    7. Copy jdbc.jar file to "\usr\sap\(SID)\SYS\exe\jvm\NTAMD64\(JVM_VERSION)\sapjvm_8\jre\lib\ext" directory of your system.

    8. Restart SAP AS Java.

    9. Voila!

    Note: You need to do same steps whenever your JVM is upgraded.

    Note: You still need to install MS Access Driver( For 32 or 64 bit Windows )

    Best Regards,

    Faruk.


    jvm-version.png (29.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.