
729
Establishing Connections and Recordsets
19
ASP
A DSN connection is often an ASP developer’s first choice for rapid development because of its easy
setup. To establish a DSN connection in Dreamweaver, follow these steps:
1. Choose Window ➪ Databases to display the Databases panel, as shown in Figure 19-5.
FIGURE 19-5
A drop-down list appears when you click the Add (+) button, enabling you to select a DSN-type connection.
2. Click the Add (+) button and select Data Source Name (DSN) from the drop-down list.
3. The Data Source Name (DSN) dialog box displays. If you’re creating a connection on a test-
ing server choose the Dreamweaver Should Connect Using DSN On Testing Server option;
otherwise, choose the Using Local DSN option. These options are not available on the Mac;
you must always use the testing server.
4. Enter a label for your new connection in the Connection Name field. It’s a good habit to
identify your connections with the prefix conn; for example, you might label your connec-
tion connDBA.
5. If you’re defining a local DSN connection, select an entry from the Data Source Name
(DSN) drop-down list.
If your DSN has not been previously declared, click Define to open the ODBC Data Source
Administrator and, as outlined in the previous section, create a new DSN. When you’re
done, the new DSN appears in the list.
6. If you are defining a DSN connection on the testing ...