MACROMEDIA COLDFUSION 5-DEVELOPING, Develop Manual

Page: 42 / 438

22 Chapter 3 Querying a Database
Adding data sources
You use the ColdFusion Administrator to add data sources to the ColdFusion
Administrator.
When you add a data source, you assign it a name so that you can reference it within
tags such as
cfquery
on application pages to query databases. During a query, the
data source tells ColdFusion which database to connect to and what parameters to
use for the connection.
Use the following procedure to add the CompanyInfo data source that you use in
many examples in this book.
Note
By default, the ColdFusion setup installs the CompanyInfo and cfsnippets databases
used in examples in this book and adds them to the available ODBC data sources.
Therefore, this procedure should not be necessary to work with examples in this
book.
To add a data source:
1 Start the ColdFusion Administrator.
On Windows, select Start > Programs > ColdFusion Server > ColdFusion
Administrator . On UNIX, enter the URL
hostname /CFIDE/administrator
in
your browser.
The Administrator prompts you for a password if you assigned one to the
ColdFusion Server during the installation.
2 Enter a password to gain access to the Administrator.
3 Select ODBC under the Data Sources heading on the left menu.