When you use ODBC connectivity using the JDBC-ODBC bridge
(supported on Windows systems
only) you can specify a database or file path the ODBC driver must
use, if the ODBC driver permits.
This type of configuration avoids having to define a data
source name for each database or file path your Connector uses.
- jdbcDriver
- sun.jdbc.odbc.JdbcOdbcDriver
- jdbcSource
- jdbc:odbc:driver name;DBQ=path
The syntax of
this parameter is dependent on the following conditions:
- MS Access is installed
- Open the ODBC data source control panel, and select the User
DSN tab. In this table you see the driver names you can use in
the JDBC Source parameter. For example, if you want to access an MS
Access database (C:\Documents and Settings\username\My
Documents\mydb.mdb), provide the following value for the
JDBC source:
jdbc:odbc:MS Access Database;dbq=C:\Documents and Settings\username\My Documents\mydb.mdb
- MS Access is not installed
- If MS Access is not installed, and you are on a Windows system, use the following value:
jdbc:odbc:Driver={MS Access Driver
(*.mdb)};dbq=C:\Documents and Settings\username\My Documents\mydb.mdb
Alternatively,
use the Windows System DSN
utility, available under
Administrative Tools -> Data
Sources (ODBC). Once you define a System DSN, use a jdbcSource
parameter like the this:
jdbc:odbc:myDSNNameHere
Check
the Driver list that you get in the utility. Your JDBC URL must exactly
match the wording found in this list.