ODBC DSN Tutorial
As part of the ASP Database Tutorial, this will show you how to set up an ODBC DSN in Windows 2000/XP.
Start by opening the Windows Control Panel, click Administrative Tools and then click Data Sources (ODBC). This should open up the ODBC Data Sources Administrator:
Click the System tab at the top, then click Add to create a System DSN. Select "Microsoft Access Driver (*.mdb)" from the list then click Finish to open up the ODBC Microsoft Access Setup screen:
Enter "Users" as the Data Source Name then click Select and locate your database. If you have password protected your Access database, click the Advanced button then enter your Login Name and Password.
Now your System DSN is ready to access in your ASP. Click OK until you return to the Windows Control Panel.
