Skip to Content
author's profile photo Former Member
Former Member

MS ACCESS - Sender JBDC connection error

Hi

I am trying to connect to MS ACCESS database (stored in local system) using JDBC sender adapter. While connecting it is giving connection error.

Error Description: Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Users\764464\Desktop\others\TestDB.mdb' using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. sun.jdbc.odbc.JdbcOdbcDriver returns: while trying to invoke the method sun.jdbc.odbc.JdbcOdbc.getTracer() of an object loaded from static field sun.jdbc.odbc.JdbcOdbcDriver.OdbcApi.

: NullPointerException: while trying to invoke the method sun.jdbc.odbc.JdbcOdbc.getTracer() of an object loaded from static field sun.jdbc.odbc.JdbcOdbcDriver.OdbcApi'.

JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver

Tried all the possible cases in the connection parameter:

Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Users\764464\Desktop\others\TestDB.mdb

Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Users/764464/Desktop/others/TestDB.mdb


I tried it with .accdb file too

Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\764464\Desktop\test\TestDB.accdb

Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:/Users/764464/Desktop/test/TestDB.accdb



after trying all the above possible cases still the same error is coming.


Gone through the several links as well.


Connecting to MS Access using receiver JDBC Ada... | SCN

Connecting SAP PI to MS Access and error resolution approach for Driver not found issue



Since the My current PI version is 7.31 (Installed on UNIX) and JDK already have the required drivers (jar files), so I assume that no additional drivers required to be installed to connect MS Access file.



Can any one help me please....



Thanks

Pavan

jdbc.JPG (45.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on May 02, 2016 at 08:34 AM

    Hi Pavan,

    Have you tried to download and install the MS Access drivers instead of the sun one? (1681420 - PI : Where to locate the JDBC Driver for Microsoft Access database)

    The driver would be "com.ms.jdbc.odbc.JdbcOdbcDriver"

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 02, 2016 at 08:35 AM

    Hi Pavan,

    There must be some error in the configuration, can you please re check your jdbc driver and connection parameters.

    Refer Mr. Rajeev suggestion in the below blog to ensure the required drivers are deployed [By Default] and visible under JDBC adapter services.

    If you don't find the driver install them.

    Regards

    Bhargava Krishna

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 02, 2016 at 12:59 PM

    Hi Pavan,

    you might try to install an ODBC driver which was created especially for Unix environment:

    Access ODBC Driver

    Best Regards,

    Viktor

    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.