110
Chapter 8 Accessing Data Sources
Introduction to Database Tools
Visual database tools support application development that uses local, network, and
remote data sources. When you configure a
server
, access to data sources becomes
transparent.
The ColdFusion Studio database tools support:
•
Developing a database remotely
•
Browsing a data source
schema
and data
•
Building SQL statements in a visual editor
For information on developing ColdFusion applications using data sources,
including requirements for native drivers, see ../
Developing_ColdFusion_Applications/contents.htmDeveloping ColdFusion
Applications/a.
Working with Data Sources
This section describes how to configure, connect to, and view data sources.
Configuring data sources
A set of ODBC drivers and sample data is installed with ColdFusion Server. Native
database drivers are installed with the Enterprise version; OLE-DB drivers are
installed with the Professional and Enterprise versions.
To add a data source to ColdFusion Server:
1
In the ColdFusion Administrator, under Data Sources, select the ODBC or native
drivers page.
2
Enter a name for the
data source
, select the appropriate driver, and click Add.
3
Click Verify.
ColdFusion Studio tests the connection and displays an error message if the
connection fails.
For more information on managing data sources, see Installing and Configuring
ColdFusion Server.
To view a Spectra database schema:
1
In the ColdFusion Administrator, click the Database tab.
2
In the top pane, select a Spectra data source from the drop-down list.
In ColdFusion Studio, you can view the
schema
for any Spectra data source that has
been added in the ColdFusion Administrator.
Содержание ColdFusion Server 5
Страница 18: ...xviii About This Book...
Страница 26: ...8 Chapter 1 Setting Up the Product...
Страница 42: ...24 Chapter 2 Configuring Browsers and Servers...
Страница 60: ...42 Chapter 3 Exploring the Workspace...
Страница 100: ...82 Chapter 6 Editing Pages...
Страница 126: ...108 Chapter 7 Using Web Development Languages...
Страница 212: ...194 Chapter 13 Customizing the Development Environment...
Страница 320: ...302 Glossary...