EVOLUTION-MANAGER

Edit File: drv_mdb.html

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2//EN">

<title>Access MDB databases</title>
</head>

<body bgcolor="#FFFFFF">
  <h1>Access MDB databases</h1>

<p>OGR optionally supports reading access .mdb
  files by using the Java <a href="http://jackcess.sourceforge.net/">Jackcess</a> library.</p>

<p>This driver is primarily meant as being used on Unix platforms to overcome the
     issues often met with the MDBTools library that acts as the ODBC driver for MDB databases.</p>

<p>The driver can detect ESRI Personal Geodatabases and Geomedia MDB databases, and will
     deal them exactly as the <a href="drv_pgeo.html">PGeo</a> and
     <a href="drv_geomedia.html">Geomedia</a> drivers do. For other MDB databases, all the tables
     will be presented as OGR layers.</p>

<h2>How to build the MDB driver (on Linux)</h2>

You need a JDK (a JRE is not enough) to build the driver.

On Ubuntu 10.04 with the openjdk-6-jdk package installed,

<pre>./configure --with-java=yes --with-mdb=yes</pre>

On others Linux flavors, you may need to specify :

<pre>./configure --with-java=/path/to/jdk/root/path --with-jvm-lib=/path/to/libjvm/directory --with-mdb=yes</pre>

where /path/to/libjvm/directory is for example /usr/lib/jvm/java-6-openjdk/jre/lib/amd64/server <p>

It is possible to add the <i>--with-jvm-lib-add-rpath</i> option (no value or "yes") to embed the path
  to the libjvm.so in the GDAL library.<p>

<h2>How to run the MDB driver (on Linux)</h2>

You need a JRE and 3 external JARs to run the driver.

<ol>
  <li>If you didn't specify --with-jvm-lib-add-rpath at configure time, set the path of the directory that contains libjvm.so in LD_LIBRARY_PATH or in /etc/ld.so.conf.</li>
  <li>Download jackcess-1.2.XX.jar (but 2.X does not with the current driver), commons-lang-2.4.jar and commons-logging-1.1.1.jar (other versions might work)</li>
  <li>Put the 3 JARs either in the lib/ext directory of the JRE (e.g. /usr/lib/jvm/java-6-openjdk/jre/lib/ext) or in another directory
  and explicitly point to each of them with the CLASSPATH environment variable.</li>
  </ol>

<h2>Resources</h2>

<ul>
  <li><a href="http://jackcess.sourceforge.net/">Jackcess</a> library home page</li>
  <li>Utility that contains the needed <a href="https://storage.googleapis.com/google-code-archive-downloads/v2/code.google.com/mdb-sqlite/mdb-sqlite-1.0.2.tar.bz2">JARs dependencies</a></lib>
  </ul>

<ul>
  <li><a href="drv_pgeo.html">PGeo</a> driver page</li>
  <li><a href="drv_geomedia.html">Geomedia</a> driver page</li>
  </ul>

</body>
</html>