User Guide

120 Chapter 6 Managing Data Sources
Installing and Configuring ColdFusion Server
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:
1Open the ColdFusion Administrator.
2 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
3Verify 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.
install.book Page 120 Thursday, May 10, 2001 12:59 PM