Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

Easysoft JDBC-Access Gateway

How do I connect A Reporting Tool (ART) to Microsoft Access?

Article:
01058
Last Reviewed:
29th January 2024
Revision:
1

Use the JDBC-Access Driver to connect A Reporting Tool (ART) to a Microsoft Access (MDB) database.

We tested ART with the JDBC-Access Driver using:

The following instructions assume that:

These instructions show how to connect ART to Microsoft Access:

  1. Download the JDBC-Access Driver.
  2. Install and license the JDBC-Access Driver on the machine where ART is installed.

    Install the JDBC-Access Driver into the default folder.

    For installation instructions, see the JDBC-Access Driver documentation.

  3. Copy esmdb.jar from the drive:\Program Files\Easysoft Limited\Easysoft JDBC-Access Gateway\32-Bits\Libs to drive:\Program Files (x86)\Apache Software Foundation\Tomcat 7.0\lib.
  4. In the Windows Taskbar Search box, search for "environment variables". Choose Environment Variables. Double-click PATH in the System variables list. Make sure that the PATH contains: 
    drive:\Program Files\Easysoft Limited\Easysoft JDBC-Access Gateway\32-Bits\Libs\

    Make sure that this folder appears before C:\Program Files\Easysoft Limited\Easysoft JDBC-Access Gateway\Libs\ in the PATH. Otherwise, you will get an "Architecture mismatch" mismatch error when you attempt to connect to Microsoft Access.

  5. Stop and start the Apache Tomcat server.
  6. Use a Web browser to connect to ART. For example: 
    http://localhost:8080/art/
  7. Once you have logged into ART, go into the Data Sources section and add a new data source:
    Field Value
    Datasource Name Easysoft
    Database Type Other
    JDBC Driver easysoft.sql.esMdbDriver
    JDBC URL jdbc:easysoft:mdb?DBQ=database

    where database is the MDB file that you want to connect to. Include the path, for example, C:/Users/Public/Northwind.mdb. Note that the forward slashes (/) in the path are deliberate, you need to use these instead of backslashes (\).

    When you click OK to save the data source, ART tests the connection. If the connection succeeds you will see the following output:

    Registering driver easysoft.sql.esMdbDriver ...
...OK

Testing connection ...
...OK
  8. Choose Finish, and then navigate to the Admin Console.
  9. Choose Queries, and then choose Create a new query:
    Field Value
    Name Easysoft Test
    Status Active
    Short Description First Easysoft Test
    Description Testing the JDBC-Access Driver with ART and Microsoft Access.
    Contact Person myperson@mydomain
    Type Tabular
    Datasource Easysoft
    Uses Rules No
    Show Parameters In Output No
    Display Resultset 0
    Source (SQL) select * from suppliers

    Replace suppliers with the name of a table in your database.
  10. Choose Save Changes, and then, to test the query, choose Execute.

    If the query succeeds, your Access data will be displayed in a new browser window.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)