Skip to Content

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

JDBC driver error to connect to an MS Access DB

Hi All,

We have created a file to JDBC scenario on XI 3.0. My XI server is on a Linux server and the db the receiver CC is trying to connect to is an MS Access 2007.

The CC parameters are configured as follow:

JDBC Driver: jdbc.odbc.JdbcOdbcDriver

Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=
xxxxxx\xxxxx\Test.mdb

On the communication monitoring we are getting the following error message:

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=
xxxxxx\xxxxx\Test.mdb': java.lang.NullPointerException

In regards with the above message and after reviewing several posts, I have two questions I would like to confirm with you:

a- Do I have to perform a JDBC driver deployment to connect to a MS Access DB? If so, which one.

b- Is there a suitable JDBC driver on Linux to connect to a MS Access DB? If there is not such a driver, Is there any available workaround for this?

Please, let us know your recommendations about this or what I should check to identify the cause of the above error.

Thanks and best regards

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