Creating Data Sources Using ColdFusion Administrator


When using ColdFusion Administrator, you need to assign a data source name and set all the information required to establish an ODBC connection. To access the database, use the data source name in the CFML tag.

ColdFusion Administrator is a Web-based, menu-driven tool. To add a data source by using Administrator, perform the following steps:

  1. Open ColdFusion Administrator in the browser. In UNIX, enter the URL hostname, CFIDE, administrator in the browser. In Windows, choose Start, Programs, ColdFusion Server, ColdFusion Administrator.

  2. Administrator prompts you for the password assigned to the ColdFusion server during installation. Enter this password to access Administrator.

  3. Select the ODBC, OLEDB, or Native Drivers link under Data Sources to set up the appropriate connection for your data source.

  4. Enter the name of the data source.

  5. Select your driver/provider type. In Windows, select Microsoft Access Driver (*.mdb) from the drop-down box to describe the ODBC driver. In UNIX, select the Merant Dbase/FoxPro driver.

  6. Click Add.

  7. In the Database File field, enter the full path of the database. You can also use Browse to locate the file. Click CF settings to go to a new page, and specify how ColdFusion should access the database.

  8. After you've configured ColdFusion-specific information, click Create to create the data source.

  9. Locate the name of the data source in the data source list.

  10. Select Verify to run the verification test on the data source.

  11. Verify whether a message confirming the connection to the data source has been displayed.

When naming a data source, follow these conventions:

  • Names should be all one word and begin with a letter. They can contain only letters, numbers, and an underscore.

  • Data source names aren't case-sensitive.

  • A data source must be defined before you can use it on an application page to retrieve data.




Macromedia ColdFusion MX. Professional Projects
ColdFusion MX Professional Projects
ISBN: 1592000126
EAN: 2147483647
Year: 2002
Pages: 200

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net