You add data sources in the ColdFusion Administrator to define connection requirements for database access.
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.
![]() |
To add a data source: |
hostname/CFIDE/administrator
in your browser.
The Administrator prompts you for a password if you assigned one to the ColdFusion Server during install.
CompanyInfo
.
company.mdb
Access database and click OK.
CompanyInfo
data source.
The data source is added to the data source list.
CompanyInfo
in the data source list.
If the data source was created, you should see this message:
The connection to the data source was verified successfully.
![]() |
Note: | For more information about managing data sources, See Administering ColdFusion Server. |
When adding data sources to ColdFusion Server, keep these guidelines in mind: