Define a MX DSN - Step I

In the previous tutorial, Define a System DSN, you created a system data source name for your computer. In this tutorial you will create a Data Source Name in Dreamweaver MX so that you can connect to your database for development.

1. File > New. When the New Document window opens, click on the General tab and select Dynamic Page in the Category column, and ASP VBScript in the Dynamic Page column. Click Create.

2. Save this file as index.asp in the root of your web site.

3. Open the Databases Panel (CTRL + SHIFT + F10) if it is not already open.

4. Click on the (+) sign in the Databases Panel and select Data Source Name (DSN).

5. In the Data Source Name (DSN) window, enter connTutorial in the Connection Name box. Then click the drop down arrow next to Data Source Name (DSN) and select the tutorial System DSN that you created earlier.

6. Click on the Test button in the Data Source Name (DSN) window and you should see the following window.

7. Click OK. Now look in the Databases Panel. You should see the connection to the database.

8. Open the Site Panel (F8) if it is not already open and notice that MX has added a folder called Connections and a file called connTutorial.asp. This page will be used as an include file on all of your pages that connect to the database.

That is all there is to creating a Dreamweaver MX Data Source Name (DSN).