To verify ColdFusion data sources on the ODBC, OLE DB or Native data source page:
In the ColdFusion Administrator navigation frame, click Server then a data sources link: ODBC Data sources, OLE DB Data Sources, or Native Data Sources.
Click CF Settings and check that the Disable database connection option is not enabled. For details, see Select ColdFusion settings.
To verify all listed sources,
click Verify All Connections and
refer to the Status column of the table. "OK" displays next
to each verified data source. "Failed" displays for any source
that could not be verified; the selection is also highlighted.
To verify an individual data source, click the Verify
link provided in the Controls column of the Connected Data Sources table.
A message tells you whether the data source was successfully verified.
Click Go Back when you finish
reviewing this message.
Notes
If a data source is protected by a username and password, you have to enter this information before you can verify the data source. To define a username and password, select a data source configuration option, then display the Edit page. Click CF Settings on the Edit page to set the username and password.
If ColdFusion cannot verify a data source, you can run a cfquery against the failed source to get details about the problem. You can also try to embed a username and password into the cfquery tag to find out whether the query works.
For help with troubleshooting Oracle, Informix, or other data sources, see the book Advanced ColdFusion Server Administration.
The Data Source Connection Summary page also allows you to View and manage data source connections.