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.NET 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 automatically updates all the pages in the site that use the connection.

If you rename a connection, update every DataSet that uses the old connection name by double-clicking the recordset in the Bindings panel and selecting the new connection name in the DataSet dialog box.

To delete a connection:

1. Open an ASP.NET page in Dreamweaver, and 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 DataSet that uses the old connection by double-clicking the name of the DataSet in the Bindings panel and selecting a new connection in the DataSet dialog box.