Set up your DSN for JDBC

Steps to Perform

1. Begin by opening the Control Panel, by choosing Start, Settings, Control Panel.
   Find the control panel item called 32-bit ODBC (on NT, it’s just called ODBC) and double-click it to launch ODBC.
   
2. So that the servlets can see the database, you need to create a System DSN on the same computer that will run your Web server. You need to bring the System DSN tab to the front by clicking the System DSN tab.
3. Click the Add button on the System DSN tab to add a System DSN.
4. Here you choose the driver to create a new data source.
   Notice I have selected the Access driver, which can read and write Access files.
   Click Finish on the dialog box to move on to creating the new data source.
5. Name your datasource and add a description before connecting this datasource name to a real database.
   In the Datasource Name field type in “ javadeploy.com”. In the Description field type in “Sample data for Java Servlets course.
   ” Since I’ve already created an Access database, click Select to browse to the path of the database.
   
6. Browse to the location of the database and select the file (I’ve done this for you). Click OK to return to the Setup dialog.
7. Click OK to accept your datasource name, description and path.
8. You can now see the new DSN added to the list.