Accessing MS ACCESS

27 Views

Hi All,

I am doing file to Jdbc scenario using MS ACCESS as database.

I have done the proper settings in CC, but getting this error in JDBC Communication Channel monitoring.

( used this blog as reference:

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

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=//sapxidev/xitemp/db/TestDB.mdb': SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.\

Please help me out from this issue.

Thanks in advance

Regards,

Vikas