Editing or deleting a database connection

When you create a database connection, Dreamweaver stores the connection information in an include file in the Connections subfolder in the site’s local root folder. You can edit or delete the connection information in the file manually or as follows.

To update a connection:

1. Open an ASP page in Dreamweaver, then open the Databases panel (Window > Databases).

   A list of connections appears in the panel.

2. Right-click (Windows) or Control-click (Macintosh) the connection and select Edit Connection from the pop-up menu.

   The dialog box you used to create the connection appears.

3. Make the changes and click OK.

Dreamweaver automatically updates the include file, which updates all the pages in the site that use the connection.

To delete a connection:

1. Open an ASP page in Dreamweaver, then open the Databases panel (Window > Databases).

   A list of connections appears in the panel.

2. Right-click (Windows) or Control-click (Macintosh) the connection and select Delete Connection from the pop-up menu.

   The dialog box you used to create the connection appears.

3. Confirm that you want to delete the connection.

   NOTE

   To avoid getting errors after deleting a connection, update every recordset that uses the old connection by double-clicking the name of the recordset in the Bindings panel and choosing a new connection.