Configure Native data sources

The Native Database Data Sources page displays existing ODBC data sources by name and driver, and the connection status (OK or Failed). Use this page to configure a new data source, edit the configuration of an existing source, and verify connections. (Note that you can also manage connections using the Datasource Connection Summary page.)

 

To configure a new source:

  1. Click Server>Native data sources in the ColdFusion Administrator navigation frame. The Native Data Source page appears.

  2. Enter a name in the Data Source Name field. ColdFusion reserves the words "Registry" and "Cookie" for use. Do not use one of these words as a data source name.

  3. Select a driver from the drop-down Driver list.  

  4. Click Add to see the Create ODBC Data Source page. The fields you see depend on the selected driver.

  5. Complete the configuration as described in the appropriate topic for your selected driver. (See the database driver topics list.)

    Note that if you are creating a UNIX data source, you might have to set environment variables for your database client library by editing the ColdFusion start script in <installdir>/coldfusion/bin. For detailed information about editing the ColdFusion start script, see the book Advanced ColdFusion Server Administration.
     

  6. You can set further specifications for the data source, such as requiring use of a username and password. Click CF Settings to see additional fields. Complete the fields as described in Select ColdFusion Settings.

  7. Click Create when you finish configuring the data source.

    ColdFusion Administrator verifies automatically that it can connect to the data source. If verification succeeds, the Data Source page displays with the new data source highlighted. If the verification fails, an error message displays. For information about troubleshooting verification failures, see the book Advanced ColdFusion Server Administration.

 

To edit a data source:

  1. On the Native Data Sources page, click a name in the Data Source Name column. The Edit ODBC Data Source page appears.

  2. Edit the configuration as described in the appropriate topic for your selected driver. as described in the appropriate topic for your selected driver. (See the database driver topics list.) To cancel your changes any time, click Cancel. Your original configuration remains intact.

  3. To set further specifications for the data source, click CF Settings to see additional fields. Complete the fields as described in Select ColdFusion Settings.

  4. Click Update when you finish changing a configuration.

    ColdFusion Administrator verifies automatically that it can connect to the data source. If verification succeeds, the Data Source page displays with the new data source highlighted. If the verification fails, an error message displays. For information about troubleshooting verification failures, see the book Advanced ColdFusion Server Administration.

Database driver topics

Related topics