Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC with MS Access: DB connection error

Hi Dear Friends!

I'm implementing scenario File->PI->(JBDC) MS Access.

I follow the links:

1. Anirban Ghatak. FILE to JDBC Adapter using SAP XI 3.0


2. Sameer Shadab. Connecting to MS Access using receiver JDBC Adapter (Without DSN)


3. JDBC Driver For MS Access

But I have such error in Communication Channel Monitoring:

Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver 
(*.mdb)};DBQ=../../../work/PIUse/PiPattern1/TestDB.mdb' using the JDBC driver 
'sun.jdbc.odbc.JdbcOdbcDriver': ' Cannot 
establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver 
(*.mdb)};DBQ=../../../work/PIUse/PiPattern1/TestDB.mdb': java.lang.NullPointerException'

In last link they say it isn't necessary to install and configure External Drivers for JDBC. (And I really have not done it yet.) My PI work on Linux platform. What I need to set or detect?

With the best regards,

Natalia Maslova.

Former Member
Not what you were looking for? View more on this topic or Ask a question