Steps in Defining a System DSN

Here are the steps you need to perform in order to create a System Data Source Name, or DSN.

  1. Open the Control Panel window.
  2. Open ODBC Data Sources (32bit) control panel.
  3. Click System DSN tab.
  4. Click Add.
  5. Select Microsoft Access Driver (*.mdb).
  6. Click Finish.
  7. Type a name for this data source in the Data Source Name field. This is the name your Web application will use to find the database.
  8. Type a short description in the Description field.
  9. Click Select.
  10. Browse for the database then click OK.
  11. Make sure the System Database radio button is set to None.
  12. Click OK.