Skip to Content
avatar image
Former Member

Accessing MS Access Database 2010 from Sender JDBC in PI 7.3

Hi All ,

We are trying to access a MS Access(2010) db file i.e test.accdb file from Sender JDBC Adapter .

We are placing the file in PI Local server

We are giving the path in connection(In Sender JDBC Adapter) as below

jdbc:odbc:Driver={Microsoft Access Driver (*.accdb)};DBQ=//PIServerdetails/folder/PI/JDBC/test.accdb

But we are not able to access the file

We are getting the following error in channel

Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.accdb)};DBQ=//PIServerdetails/folder/PI/JDBC/test.accdb 'using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. sun.jdbc.odbc.JdbcOdbcDriver returns: [unixODBC][Driver Manager]Data source name not found, and no default driver specified. : SQLException: [unixODBC][Driver Manager]Data source name not found, and no default driver specified'

Could any one please let us know how to proceed with the issue

Thanks

Swathi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers