Skip to Content

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

JDBC Receiver Adapter

Hi everyone,

I am trying to connect to MSAccess database and gave the comm channel config as per this weblog

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

My driver is -->> sun.jdbc.odbc.JdbcOdbcDriver

My connection is -->> jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//windowsservername/Tables/Lookup.mdb

My Adapter Monitor gives me this exception

Error: Accessing database connection 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=//windowsservername/Tables/Lookup.mdb' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=//windowsservername/Tables/Lookup.mdb': java.lang.NullPointerException

The database is in Windows system and XI is in Unix system - sp16. I could ping the windows system from XI box....I have a username and pwd configured in the JDBC adapter - under Username/ password section.

Do I need to have any Data source createdin XI for that database inorder to connect to it?

Thanks and I appreciate your responses..

Thilothama

Helpful Answer

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