F IGURE 7.8
The Create New Data Source screen.
Select the Microsoft Access Driver and click the Finish button. You will now see the
ODBC Microsoft Access Setup screen. Figure 7.9 shows this screen.
F IGURE 7.9
The ODBC Microsoft Access Setup screen.
Enter the string “Movie Catalog” as the data source name and click the database Select
button. Enter the path to the location of your moviecatalog.mdb file and click OK. You
will now see the ODBC Microsoft Access Setup screen with your changes displayed.
Click OK to commit to your changes.
You will now see the ODBC Data Source Administrator screen with the Movie Catalog
data source in the list. Click the OK button to close this window.
Establishing a Database Connection
The first thing you need to do when using the JDBC is establish a connection to the database.
This is a two-step process. You must load the JDBC driver and then make a connection.