*
Metamerge logo
Search

Advanced Search
*
*
*
* HOME DOCUMENTS & RESOURCES DOWNLOADS EARLY TECH ACCESS SUPPORT FAQ KNOWN ISSUES OLD VERSIONS
*

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>

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

 

 
*
  Metamerge Integrator version 4.5 ©Copyright Metamerge AS 2000-2002 Last edited 2002-04-30 contact us