Error in Sender JDBC adpter

[Former Member]

Hi,

I got the following error in sender communication channel monitoring.

Error during database connection to the database URL 'jdbc:odbc:Driver = (Microsoft Access Driver (.mdb)); DBQ = //db/TestDB.mdb using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver = (Microsoft Access Driver (.mdb)); DBQ = //172.19.61.54/jdbc/T': java.lang.NullPointerException'

Pleae help me to solve this error.

Thanks,

Sreedivia

[Former Member]

hi

check whether MS Access drivers deployed correctly or not

check with the basis team

also check this blog

Connecting to MS Access using receiver JDBC Adapter

regards

kummari

[Former Member]

if u r using MS ACCESS 2007, u need to install driver in SAP XI.

as SAP XI dont have default driver for MS ACCESS 2007

[Former Member]

Hi,

This is an ever green problem, I faced the same problem too.

for this you need to install patches that are downloaded from service market place and update XI.

check with your Basis team for the same.

Best Regards

Praveen

[prateek]

Ur communciation channel driver settings could be incorrect. Can u mention ur connection string here as u mentioned in CC.

Regards,

Prateek

[Former Member]

Hi Pratheek,

JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver

Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ = //172.19.61.54/jdbc/T.mdb

Regards

Sreedivia

[prateek]

Hmm. Looks good enuf.

Just try with following driver jdbc.odbc.JdbcOdbcDriver.

Also make sure ur database name is T.mdb and not TestDB.mdb as seen in the error. Also save and reactivate the CC once.

Regards,

Prateek