How to create a DSN (Data Source Name)?

Select the "ODBC Data Source (32bit)" in the "Control Panel", and double click it:

The "ODBC Data Source Administrator" dialog box will pop up; select the "System DSN". This is because of the ASP file that is running in the IIS or PWS.

After that, click the "Add..." Button:

The "Create New Data Source" dialog box will come up. Select the "Microsoft Access Driver (*.mdb)" and click the "Finish" button:

The "ODBC Microsoft Access Setup" dialog box will come up.

Give the data source a name and type it into the "Data Source Name" field.

After that, click the "Select..." button:

The "Select Database" dialog box will come up. Get the location of the database; then click OK:

The Database location will be shown here:

Finally, Click the OK button.

The DSN that you created will be shown here: