Creating or modifying a ColdFusion data source

Before you can use database information in your page, you must create a ColdFusion data source. If you’re running ColdFusion MX 7 or later you can create or modify the data source directly in Dreamweaver. If you’re running ColdFusion MX, you must use the server’s management console, ColdFusion MX Administrator, to create or modify the data source. You can still use Dreamweaver to open ColdFusion MX Administrator in that case.

To create or modify a ColdFusion data source if running ColdFusion MX 7 or later:

1. Make sure a computer running ColdFusion MX 7 or later is defined as a testing server for your site.

   For more information, see Enabling the ColdFusion enhancements.

2. Open any ColdFusion page in Dreamweaver.
3. To create a new data source, click the Plus (+) button in the Databases panel (Windows > Databases) and enter the parameter values specific to the database driver in the dialog box that appears.

   NOTE

   Dreamweaver displays the Plus button only if you’re running ColdFusion MX 7 or later.

   For more information, see the driver vendor’s documentation or consult your system administrator.

4. To modify a data source, double-click the database connection in the Databases panel and make your changes in the connection dialog box that appears.

   You can edit any parameter except the name of the data source. For more information, see the driver vendor’s documentation or consult your system administrator.

To create or modify a ColdFusion data source if running ColdFusion MX 6.1 or 6.0:

1. Open any ColdFusion page in Dreamweaver.
2. In the Databases panel (Window > Databases) in Dreamweaver, click the Modify Data Sources icon in the panel toolbar.

   ColdFusion MX Administrator opens in a browser.

3. Log in to ColdFusion MX Administrator and create or modify the data source.

   For instructions, see Using ColdFusion (Help > Using ColdFusion).

   You must provide certain parameter values to create the ColdFusion data source. For the parameter values specific to your database driver, see the driver vendor’s documentation or consult your system administrator.

Once you create a ColdFusion data source, you can use it in Dreamweaver. For more information, see Connecting to the database in Dreamweaver.