Configuring ODBC Data Sources for Windows  
 
 

Although you can use any valid ODBC data source on your system as a ColdFusion data source, creating, or registering, the data source in ColdFusion allows you to use the extended options available through ColdFusion. Valid ODBC data sources already on your system are available to your ColdFusion pages, but unless they are registered with ColdFusion they cannot be configured with ColdFusion-specific options. For more information see ColdFusion Settings .

 
 
  To add an ODBC data source to ColdFusion:  
 
  1. Open the ColdFusion Administrator by clicking on the ColdFusion Administrator icon in the ColdFusion program group (Windows) or by opening the Administrator URL:
    http://hostname/CFIDE/administrator/index.cfm
    

    The Administrator opens by default on the Server Settings page.

  2. Click the ODBC link under the Data Sources label. The ODBC Data Sources page appears.

  3. Enter a name for the new data source and select an ODBC driver from the drop down list. Click Add.
 
 
  Note  
 

When naming a ColdFusion data source, do not use the following names: Registry or Cookie.

  1. At the Create ODBC Data Source page, enter information about the new data source.

    For information about ODBC for specific data source types, see ODBC Data Source Options (Windows) or ODBC Data Source Options (Solaris) .

  2. If you make edits to the data source settings, click the Update button to save those changes.
  3. Click the CF Settings button to access a number of ColdFusion-related ODBC options. For more information about these ColdFusion settings, see ColdFusion Settings .
  4. Click the Verify Data Source link in the Administrator navigation bar to verify your data source. See Verifying ColdFusion Data Sources .


 
 
BackUp LevelNext
 
 

allaire     AllaireDoc@allaire.com
    Copyright © 1998, Allaire Corporation. All rights reserved.