Contents > Configuring and Administering ColdFusion MX > Data Source Management > Adding data sources > Adding data sources in the Administrator

Adding data sources in the Administrator

You use the ColdFusion MX Administrator to quickly add a data source for use in your ColdFusion applications. When you add a data source, you assign it a data source name (DSN) and set all information required to establish a connection.

Note: ColdFusion MX includes several data sources that are configured by default, including cfsnippets, CompanyInfo, and exampleapps. This procedure should not be necessary to work with these data sources.

To add a data source:

1. In the ColdFusion MX Administrator, select Data & Services > Data Sources.
2. Under Add New Data Source, enter a Data Source Name; for example, MyTestDSN. The following names are reserved. You cannot use them for data source names:
   • service
   • jms_provider
   • comp
   • jms
3. Select a Driver from the drop-down list box; for example, Microsoft SQL Server.
4. Click Add.

   A form for additional DSN information appears. The available fields in this form depend on the Driver that you selected.

5. In the Database field, enter the name of the database; for example, Northwind.
6. In the Server field, enter the network name or IP address of the server that hosts the database, and enter any required Port value; for example, the bullwinkle server on the default port.
7. If your database requires login information, enter your Username and Password.

   Tip: The omission of required username and password information is a common reason why a data source fails to verify.

8. (Optional) Enter a Description.
9. (Optional) Click Show Advanced Settings to specify any ColdFusion-specific settings; for example, to configure which SQL commands can interact with this data source.
10. Create Submit to create the data source.

    ColdFusion MX automatically verifies that it can connect to the data source.

11. (Optional) To verify this data source later, click the verify icon:

    Note: To check the status of all data sources available to ColdFusion MX, click Verify All Connections.

Contents > Configuring and Administering ColdFusion MX > Data Source Management > Adding data sources > Adding data sources in the Administrator

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/datasou5.htm

Add Comment