Verifying ColdFusion Data Sources

When you add or update a ColdFusion data source, the ColdFusion Administrator automatically attempts to verify the connection. A verified connection means that the data source is available to your ColdFusion application pages. The ColdFusion Administrator includes a facility for verifying some or all ColdFusion data sources of a particular type (ODBC, OLE DB, or native drivers) at any time.

Note

You might need to supply a username and password for the data sources that you want to verify. To define a username and password for a data source, edit the properties for the data source.

To verify a ColdFusion data source:

Open the ColdFusion Administrator.
Under Data Sources, click the link that specifies the type of data source that you want to verify:
- ODBC
- OLE DB (available only on Windows NT/2000)
- Native
Verify the data source(s):
- To verify all the data sources listed on the page, click Verify All Connections.
- To verify an individual data source, click Verify in its row.
  In the Status field, ColdFusion indicates whether the data source was successfully verified.

Note

If ColdFusion cannot verify a data source, you can run a cfquery against the failed data source to get more detailed information about the problem. You can also embed a username and password into the cfquery tag to test if the query works.

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

Version 5.0

Installing and Configuring ColdFusion Server
Managing Data Sources