JDBC connectivity - MS Access

256 Views

hi I am configuring jdbc sender adapter for fetching the data from the MS -Access remotely.

With available connection parameter , when I am running java program then its running fine but when I am using the same driver connection information then its giving error.

I have already tried all the blogs available on sdn but not able to sort out this issue.

Now I am getting this error at jdbc communication channel lavel.

"

Error during database connection to the database URL 'jdbc:odbc:Driver = {Microsoft Access Driver (.mdb)};DBQ= //<server IP>/test/Test1.mdb' using the JDBC driver 'jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver = {Microsoft Access Driver (.mdb)};DBQ= //<server IP>/test/Test1.mdb': SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'

"

At sender adapter configuration Level--> I give

Transport Protocol: JDBC 2.0

Message Protocol : JDBC

JDBC DRIVER: jdbc.odbc.JdbcOdbcDriver

Connection : jdbc:odbc:Driver = {Microsoft Access Driver (*.mdb)};DBQ= //<IP Address>/test/Test1.mdb

--> One more thing Can I use the same connection string at udf level in Message Mapping . for ex . Can I create udf -> putting same java code , where at run time it will fatch some data based on the query written in java"

Please share me ur input for the same.

regards

Ram