Dreamweaver MX ASP Tutorials Macromedia Dreamweaver MX

Define a System DSN - Step II

4. When the OBDC Microsoft Access Setup window appears, type the name of the DSN in the Data Source box. In this tutorial, we will use tutorial. Click on the Select button.

OBDC Microsoft Access Setup

5. In the Select Database window, browse to your database and select it. Click the OK button.

NOTE: For added security you should store your database above the root folder of your web site. If you store it in the root folder, or a sub-folder of the root folder, someone might be able to guess your database filename and download it.

Select Database

6. Click OK in the OBDC Microsoft Access Setup window.

OBDC Microsoft Access Setup

7. The OBDC Data Source Administrator window should now look like the following.

OBDC Data Source Administrator

That is all there is to creating a System DSN on Windows 2000.

Click here to continue the tutorial.