Operation Manual

524
USING DREAMWEAVER
Preparing to build dynamic sites
Last updated 3/28/2012
2 In the Server Behaviors panel, click the Plus (+) button and select Show Region > Show Region If Recordset Is Not
Empty.
3 Select the recordset supplying the dynamic content and click OK.
4 Repeat steps 1 to 3 for each element of dynamic content on the page.
Troubleshooting MySQL error messages
One common error message that you might encounter when testing a PHP database connection to MySQL 4.1 is
“Client does not support authentication protocol requested. Consider upgrading MySQL client.”
You may have to revert to an earlier version of MySQL, or install PHP 5 and copy some dynamic link libraries (DLLs).
For detailed instructions, see
“Setting up a PHP development environment” on page 507.
Removing connection scripts
Using the Remove Connection Scripts command
You can use the Remove Connection Scripts command to remove scripts that Dreamweaver places in a remote folder
to access databases. These scripts are only needed for design-time authoring in Dreamweaver.
When you select the Using Driver On Testing Server option or the Using DSN On Testing Server option in the
Database Connections dialog box, Dreamweaver uploads an MMHTTPDB script file to the testing server. This allows
Dreamweaver to manipulate the remote database driver with the HTTP protocol, which in turn allows Dreamweaver
to get the database information it needs to help you create your site. However, this file does make it possible to see the
data source names (DSNs) defined on the system. If the DSNs and databases are not password protected, the script
also enables an attacker to issue SQL commands to the database.
The MMHTTPDB script files are located in the _mmServerScripts folder, which is located in the root of your website.
Note: The Dreamweaver file browser (the Files panel) hides the _mmServerScripts folder. You can see the
_mmServerScripts folder if you use a third-party FTP client or the file browser.
In some configurations these scripts are not necessary at all. The scripts are not involved when serving web pages to
visitors to your website, so they should not be placed on a production server.
If you’ve uploaded the MMHTTPDB scripts file to a production server, you should delete the MMHTTPDB scripts
file. The Remove Connection Scripts command automatically removes the script files for you.