Creating a System Data Source Name (DSN)

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

  1. Open ODBC Data Source Administrator.
  2. Click System DSN tab.
  3. Click Add.
  4. Select the appropriate driver for your database type.
  5. Click Finish.
  6. 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.
  7. Type a short description in the Description field.
  8. Click Select.
  9. Browse for the database.
  10. Highlight the database file name.
  11. Click OK to select the database and close the Select Database window.
  12. Click OK to close the database setup window.
  13. Click OK to close the ODBC Data Source Administrator.