Adobe 38000827 Administration Guide - Page 40

Adding data sources, Adding data sources in the Administrator, Data & Services > Data Sources

Get Adobe 38000827 - Macromedia ColdFusion MX Standard Edition PDF manuals and user guides
UPC - 718659577186
View all Adobe 38000827 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 40 highlights

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. 32 Chapter 3 Data Source Management

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
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.