Database Set Up

1. First, let us set up an ODBC data source for our database that the JDBC datasource can use.
2. Go to the control panel and Double click 'administrative tools'.
3. Double click on ODBC data sources.
4. Move to the 'system dsn' tab by clicking on it. Click on the 'add' button.

Screen Shot 10c: The System DSN tab

5. Select 'Microsoft Access Driver' and click on 'finish'.

Screen Shot 10d: Select the ODBC Driver

6. In the next pop up, enter 'fruits' next to 'name' and a short description next to 'description'.
7. Click on 'select' in the database box. Now, select the filename and directory that corresponds to the path on your computer to fruits.mdb. Make sure the fruits database is closed when you do this. Hit OK. Our data source is now ready.

Screen Shot 10e: Enter values for your Datasource