ODBC - Specifying database paths directly
When you use the JDBC/ODBC Connector you can, if the ODBC driver permits,
specify a database/file path the ODBC driver should use. This type of
configuration avoids having to define a data source name for each database/file
path your Connector will use.
jdbcDriver |
sun.jdbc.odbc.JdbcOdbcDriver |
jdbcSource |
jdbc:odbc:<driver name>;DBQ=<path> |
If MS Access is not installed
If not, provided that you are on a Windows system use the syntax
jdbc:odbc:Driver={MS Access Driver (*.mdb)};dbq=c:\my documents\mydb.mdb
If MS Access is installed
Open the ODBC data source control panel a select the User DSN tab. In this
table you will see the driver names you can use in the JDBC Source parameter.
The picture below shows the MS Access database driver highlighted.

For example, if you want to access an MS Access database "c:\my
documents\mydb.mdb" you would provide the following value for the JDBC
source:
jdbc:odbc:MS Access Database;dbq=c:\my documents\mydb.mdb
|