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.

Installing and Configuring ColdFusion Server
Managing Data Sources