MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manuale Utente Scaricare il pdf (Pagina 40)

32 Chapter 3 Data Source Management

Adding data sources

In the ColdFusion Administrator, you configure your data sources to communicate with

ColdFusion. Once you add a data source to the Administrator, you access it by name in

any CFML tag that establishes database connections; for example,

cfquery. During a

query, the data source tells ColdFusion which database to connect to and what

parameters to use for the connection.

The ColdFusion Administrator organizes all the information about a ColdFusion MX

server’s database connections in a single, easy-to-manage location. In addition to adding

new data sources, you can use the ColdFusion Administrator to correct for changes to

your database, such as relocation, renaming, or changes in security permissions.

Adding data sources in the Administrator

You use the ColdFusion 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 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 Administrator, select Data & Services > Data Sources.

2 Under Add New Data Source, enter a Data Source Name; for example, MyTestDSN.

1 2 ... 35 36 37 38 39 40 41 42 43 44 45 ... 67 68

Nessun commento

MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manuale Utente Pagina 40