Configuring ODBC on Windows

If you want to execute the tutorial examples Displaying Data from a Database, Displaying Data from a Database With Headers and Defining Spans Based on Structure, you need to create a link to the Access 97 MDB file (sales.mdb). This document describes the configuration of the ODBC driver running on Windows 95/98/NT/2000 platform.

The first step is to run the ODBC Administrator (Note) and add the new Link.

• Select the [System DSN] Tab
• Press [Add] Button

• Choose Microsoft Access Driver (*.mdb)

• Type in the field Data Source Name: Sales
• Type in the field Description: Access DB used in JSmartGrid Tutorial
• Press on [Select] Button

• Then choose the sales.mdb Access 97 file Database: C:\Program Files\Eliad Technologies\JSmartGrid\Tutorial\ressources\databases\sales.mdb

• The next step is to check that the Link in the [System DSN] is a mdb driver.

Now, you can run the examples.

Note:
Your login must have administrator privilege.
On Windows 2000 the ODBC Administrator is located in Control Panel=>Administrative Tools.
On Windows 95/98/NT the ODBC Administrator is located in Control Panel.