JDBC TO JDBC adapter

[Former Member]

Hi ,

i am using JDBC to JDBC adapter.in my scenario sender comunication channel is in error.

Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)} ;DBQ=C:\xifile\Student_Database.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=C:\xifile\Student_Database.mdb': java.lang.NullPointerException'

please help.

[Former Member]

Can you change your string from:

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)} ;DBQ=C:\xifile\Student_Database.mdb

to:

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/xifile/Student_Database.mdb

I think you have checked this blog:

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

but if you note try to check it.

Edited by: Arman Eker on Jun 11, 2010 11:07 AM

[Former Member]

not resolved

Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)} ;DBQ=/home/iqxadm/xifiles/mohittest/sender/Student_Database.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=/home/iqxadm/xifiles/mohittest/sender/Student_Database.mdb': java.lang.NullPointerException'

[Former Member]

Hi,

if you dont use C:/

then use DBQ=//home/iqxadm/xifiles/mohittest/sender/Student_Database.mdb