Registering Data Sources

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

Note To register a data source:
  1. Open the ColdFusion Administrator.
  2. Select the ODBC or native drivers page under the data sources heading.
  3. Name the data source, select the appropriate driver, and click Add.

To test the connection, click Verify. A help message displays if the test connection fails.

For more information on managing data sources, see Administering ColdFusion Server.

Accessing Allaire Spectra data sources

Allaire Spectra data sources registered in the ColdFusion Administrator are viewable in Studio. Select a data source from the dropdown list in the top pane of the Database tab to see the database schema.

The SQL Builder, available on the Tools menu, gives you a visual interface for selecting tables and writing and testing SQL statements for your applications. You can copy completed SQL code blocks directly into your applications or insert them as part of a CFQUERY tag.