Skip to Content
0
Former Member
Nov 28, 2011 at 05:37 AM

Error connecting to MS access

25 Views

Hi All,

I have a file to jdbc scenario.

PI 7.0 is installed on Windows...

I have created a table T1.mdb on the server iitself..

I am unable to connect..

Pls share ur thoughts..

Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=F:\usr\sap\trans\T1.mdb' 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: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. : SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'