MS ACCESS - Sender JBDC connection error

[Former Member]

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

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

[former_member204100]

Hi Pavan,

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

Access ODBC Driver

Best Regards,

Viktor

[Bhargavakrishna]

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

[iaki_vila]

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.