Using ColdFusion Studio
Accessing Data Sources

Working with Data Sources

This section describes how to configure, connect to, and view data sources.

Configuring data sources

A set of ODBC drivers and sample data is installed with ColdFusion Server. Native database drivers are installed with the Enterprise version; OLE-DB drivers are installed with the Professional and Enterprise versions.

To add a data source to ColdFusion Server:

1. In the ColdFusion Administrator, under Data Sources, select the ODBC or native drivers page.
2. Enter a name for the data source, select the appropriate driver, and click Add.
3. Click Verify.

   ColdFusion Studio tests the connection and displays an error message if the connection fails.

For more information on managing data sources, see Installing and Configuring ColdFusion Server.

To view a Spectra database schema:

1. In the ColdFusion Administrator, click the Database tab.
2. In the top pane, select a Spectra data source from the drop-down list.

In ColdFusion Studio, you can view the schema for any Spectra data source that has been added in the ColdFusion Administrator.

Connecting to data sources

Data sources that are registered in the ColdFusion Administrator are automatically accessible from the Database tab in ColdFusion Studio. To access remote data sources, you can add remote ColdFusion servers (RDS servers).

To add a remote server:

1. At the bottom of the Resources window, click the Database tab.

   This is how the tab looks:

   

2. In the top pane, select Add RDS Server from the drop-down list.
3. Enter information in the Configure RDS Server dialog box and click OK.

   For information about configuring a RDS server, see "Working with Files on Remote Servers".

Viewing data sources

As soon as a data source has been added in the ColdFusion Administrator, you can view it in ColdFusion Studio.

To open a data source:

1. In the Resources window, click the Database tab.
2. In the top pane, select a server from the drop-down list.

   Accessing a large database on a remote servers might take a few moments.

3. Expand the data source tree:
   • To expand the tree, click the plus sign (+) next to a data source name
   • To view the database schema, click the plus sign (+) next to Tables
   • To view the column definitions, click the plus sign (+) next to a table name
4. Double-click a table name.

   The records in the table are displayed.

In the data browsing window you only can browse data. You cannot modify data or add new records here. Also, views are available only in databases supporting the creation of views or tables stored as queries.

To insert column or table names into a page:

• Drag a table or column from the Database tab to the Editor, to the desired position in your document.

  This is a useful shortcut when you are building database reports.

Copyright © 2001, Macromedia Inc. All rights reserved.

LiveDocs comments are not longer enabled for ColdFusion 5.0. Please use one of the following resources instead.

ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 5.0