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.
![]() |
To register a data source: |
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.
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.