database access problem

Hi,

i'm trying to access the file x.accdb with a database reader:

Database Driver: jdbc.odbc.JdbcOdbcDriver

URL: jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=j:\tmp\x.accdb

query: SELECT * FROM MyTABLE

Error:

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

 

Thanks

Hi,

you first need to setup the ODBC data source befor accesing it via the JDBC-ODBC driver. Once you have created the ODBC data source you can access it via the JDBC-ODBC driver based on its unique name.

Bye,

Tobias