Macromedia dreamweaver 8-using dreamweaver User Manual

Page of 1030
632
Chapter 26:  Database Connections for ASP Developers
Related topics
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.
NO
TE
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.