Overview

Create a data source

Data & Services > Data Sources

 

The ColdFusion Administrator lets you quickly create a data source so that your ColdFusion applications can interact with various databases.

To create a data source:

  1. In the Add New Data Source area of the Data Sources page, enter a data source name.

  2. Select a driver from the drop-down list box.

  3. Click Add. A form appears that requests additional information. The available fields in this form depend on the driver that you selected. The following names are reserved; you cannot use them for data source names:

    4. service

    jms_provider

    comp

    jms

  4. In the Database field, enter the name of the database.

  5. In the Server field, enter the network name or IP address of the server that hosts the database, and enter any required port value. The ColdFusion Administrator suggests typical default ports, such as 1433 for SQL Server. For more information, see the "Connect to..." topic for your database in the Related topics.

  6. If your database requires login information, enter your user name and password.

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

  1. (Optional) Enter a description.

  2. (Optional) Click Show Advanced Settings to specify any additional settings; for example, to configure which SQL commands will interact with this data source. For more information, see the "Connect to..." topic for your database in the Related topics.

  3. Click Submit to create the data source. ColdFusion automatically verifies that it can connect to the data source.

  4. (Optional) To verify this data source later, click the Verify All Connections icon.

Related topics