Installation guide

4. Accessing Popular Databases

4.2 MS Access Database

4.2.1 Available ODBC Drivers

MS Access ODBC Driver

Tested with MDAC 2.8 SP1 Access ODBC driver.

MS Access ships with an ODBC driver for the database which is then installed on

the same machine as MS Access (or Office). The drivers are also available

separately as part of the MDAC package.

MDAC 2.8 SP1 can be downloaded from this page:

http://www.microsoft.com/downloads/details.aspx?familyid=78CAC895-EFC2-

4F8E-A9E0-3A1AFBD5922E&displaylang=en

MDBTools ODBC Driver

Homepage: http://mdbtools.sourceforge.net/

This package provides a very limited ODBC driver which allows accessing Access

database files directly without having to install or run MS Access. It is mostly used

on Unix platforms to extract data from existing MS Access database files.

4.3 Oracle

4.3.1 Available ODBC Drivers

Oracle Instant Client ODBC driver

Homepage: http://www.oracle.com/technology/tech/oci/instantclient/index.html

Tested with Oracle Instant Client ODBC driver 11.2.

The Oracle Instant Client ships with an ODBC driver (part of the ODBC

Supplement) for most supported platforms.

mxODBC works well when using the Oracle Instant Client 11.2 with the

unixODBC ODBC manager package

mx.ODBC.unixODBC on Unix or the

mx.ODBC.Windows package on Windows.