Skip to Content
Former Member
Aug 17, 2007 at 03:03 PM

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.