| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> |
| <html> |
| <head> |
| <meta http-equiv="CONTENT-TYPE" content="text/html;> |
| <style type="text/css"> |
| <![CDATA[ */ |
| @import url("/css/dba.css"); |
| /* ]]> |
| </style> |
| <title>Linux MDB driver - alpha version</title> |
| <script type="text/javascript" src="/js/dba_default.js"></script> |
| </head> |
| <body> |
| <b>Project Sections</b>: |
| <a href="../../index.html">Home</a> |
| | <a href="../../specifications/index.html">Specifications</a> |
| | <a href="../../QA/index.html">QA</a> |
| | <a href="../../development/index.html">Development</a> |
| | <a href="../index.html"><b>Database Drivers</b></a><br/> |
| <b>Database drivers</b>: |
| <a href="../postgresql/index.html">PostgreSQL</a> |
| | <a href="../mdb/index.html"><b>Linux MDB</b></a> |
| | <a href="../sqlite/index.html">SQLite</a> |
| <hr/> |
| <div class="dba"> |
| <h1 id="mdb_driver">mdb-sdbc-driver-0.1.0</h1> |
| |
| <p><span style="font-size:xx-large"><b>Note</b></span>: This driver does not reflect the latest development anymore. If you want to test the latest version, |
| then please download the complete |
| <a href="http://ooo.services.openoffice.org/pub/OpenOffice.org/cws/upload/mdbdriver02/">OpenOffice.org snapshot</a> |
| containing the latest and greatest driver.</p> |
| |
| <p>This snapshot has been taken from |
| <a href="http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Id=2959&Path=SRC680%2Fmdbdriver02">CWS mdbdriver02</a>, where the |
| actual development takes place.</p> |
| |
| <p>If you download it, and want to share your feedback (please do so!), send a mail to |
| <a href="mailto:users@dba.openoffice.org">users@dba.openoffice.org</a>. Thanks.</p> |
| |
| <h2>Content</h2> |
| <ul> |
| <li> |
| <p style="margin-bottom: 0cm;"><a href="#intro">Introduction</a> |
| </p> |
| </li> |
| <li> |
| <p style="margin-bottom: 0cm;"><a href="#install">Installation</a> |
| </p> |
| <ul> |
| <li> |
| <p style="margin-bottom: 0cm;"><a href="#datasource">Adding a datasource</a> |
| </p> |
| </li> |
| <li> |
| <p style="margin-bottom: 0cm;"><a href="#url">Url format</a> |
| </p> |
| </li> |
| <li> |
| <p style="margin-bottom: 0cm;"><a href="#api">Using the driver via the API</a> |
| </p> |
| </li> |
| </ul> |
| </li> |
| <li> |
| <p style="margin-bottom: 0cm;"><a href="#features">Features</a> |
| </p> |
| </li> |
| <li> |
| <p style="margin-bottom: 0cm;"><a href="#questions">Open questions</a> |
| </p> |
| </li> |
| <li> |
| <p style="margin-bottom: 0cm;"><a href="#source">Building from source</a> |
| </p> |
| </li> |
| <li> |
| <p><a href="#author">Author</a> |
| </p> |
| </li> |
| </ul> |
| <h2><a name="intro"></a>Introduction</h2> |
| <p><a name="install"></a>Use <a href="http://sf.net/projects/mdbtools">MDB Tools</a> |
| to read Microsoft Access files under linux. |
| </p> |
| <h2>Installation</h2> |
| <ol> |
| <li> |
| <p style="margin-bottom: 0cm;">download <a href="http://prdownloads.sourceforge.net/mdbtools/mdbtools-0.5.tar.gz"> |
| mdbtools 0.5.0 source tarball</a> from mdbtools.sourceforge.net. |
| </p> |
| </li> |
| <li> |
| <p style="margin-bottom: 0cm;">unpack |
| </p> |
| </li> |
| <li> |
| <p style="margin-bottom: 0cm;">apply this <a href="diff-mdbtools.diff">patch</a>. |
| Build and install mdbtools. See <a href="http://mdbtools.sourceforge.net/install/"> |
| MDB Tools Installation Guide</a> for detail. |
| <br> |
| Patch for mdbtools cvs HEAD is <a href="diff-mdbtools-cvs-2004-01-19.diff">here</a>.<br> |
| </p> |
| </li> |
| <li> |
| <p style="margin-bottom: 0cm;">Install a OpenOffice.org1.1 or newer if you have |
| not done so already. |
| </p> |
| </li> |
| <li> |
| <p>Download the binary version of the driver. |
| </p> |
| </li> |
| </ol> |
| <p><a name="datasource"></a><a href="mdb-sdbc-0.1.0.zip">mdb-sdbc-driver-0.1.0.zip</a><br> |
| Copy the zip file in <code>OpenOffice1.1/user/uno_packages</code> folder (Note: |
| USE the zip file as a whole, DO NOT extract it). Open up a shell and switch to |
| the OpenOffice1.1/program directory and start the pkgchk tool. On success, no |
| output is given. Alternatively, you can install the driver for all users of a |
| OpenOffice.org network installation by placing the file into the <code>OpenOffice1.1/share/uno_packages</code> |
| and starting pkgchk --shared You can uninstall the package by deleting the file |
| in the uno_packages directory and starting pkgchk again. |
| </p> |
| <h3>Adding a datasource</h3> |
| <p><a name="url"></a>You can now add a datasource via the common Tools/Data |
| Sources dialog. Click on new datasource and select mdb from the Database type |
| combobox. You should currently put the file name of your mdb file into url |
| line. |
| </p> |
| <h3>URL format</h3> |
| <p>Format: <code>sdbc:mdb:mdb_filename </code> |
| </p> |
| <h3><a name="api"></a>Using the driver via the API</h3> |
| <p>To DO |
| </p> |
| <h2><a name="features"></a>Supported and missing features</h2> |
| <p><a name="DDE_LINK1"></a>The driver currently is implemented using the patched |
| MDBTOOLS v0.5. It currently has read-only support for Access 97 (Jet 3) and |
| Access 2000/2002 (Jet 4) formats. And it has following limitations: |
| </p> |
| <ol> |
| <li> |
| <p style="margin-bottom: 0cm;"><a name="DDE_LINK2"></a>It does not support i18n. |
| It means that you can only use it to access English date in a MS Access MDB |
| file. You can't use it to read Chinese , Japanese data and so on. |
| </p> |
| </li> |
| <li> |
| <p style="margin-bottom: 0cm;">It is a readonly driver,you can't use to to write |
| data into a mdb file. |
| </p> |
| </li> |
| <li> |
| <p>It only supports a small set of sql language. Such as</p> |
| <p>select * from table_name</p> |
| <p><a name="DDE_LINK3"></a><a name="DDE_LINK4"></a>select * from ¡°table_name¡± |
| where col1 = 1 and col2 < 10 |
| </p> |
| <p>select col1 from table_name where col1 = 1 |
| </p> |
| <p>select ¡°col1¡± from table_name where col1 = 1 and col2 < 10 |
| </p> |
| <p><a name="DDE_LINK5"></a></p> |
| </li> |
| </ol> |
| <p><br> |
| <br> |
| </p> |
| <h2><a name="questions"></a>Open questions</h2> |
| <h2><a name="source"></a>Building from source</h2> |
| <p>To DO |
| </p> |
| <h3>Test</h3> |
| <p>To DO. |
| </p> |
| <h2><a name="author"></a>Authors</h2> |
| <p style="margin-bottom: 0cm;">The driver has been implemented and is maintained |
| by Wind Li (yl146652@openoffice.org). |
| </p> |
| </div> |
| </body> |
| </html> |
