130
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 H for Dreamweaver MX database tools support:
•
Developing a database remotely
•
Browsing a data source schema and data
•
Building SQL statements in a visual editor
Working with data sources
This section describes how to configure, connect to, and view ColdFusion data
sources. It assumes that ColdFusion Server is installed and running properly.
Configuring a ColdFusion data source
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.
H for Dreamweaver MX tests the connection and displays an error
message if the connection fails.
Connecting to a data source
Data sources that are registered in the ColdFusion Administrator are automatically
accessible from the Database tab in H for Dreamweaver MX. To access
remote data sources, you can add remote ColdFusion Servers (RDS servers).
To add a remote server:
1
At the bottom of the Resources window, click the Database tab.
This is how the tab looks:
2
In the top pane, select Add RDS Server from the drop-down list.
Summary of Contents for HOMESITE
Page 11: ...Contents xi Table of CommandID values 310 Table of SettingID values 314 Glossary 323...
Page 12: ...xii Contents...
Page 20: ...xx About This Book...
Page 28: ...8 Chapter 1 Setting Up the Product...
Page 70: ...50 Chapter 4 Managing Files...
Page 88: ...68 Chapter 5 Writing Code and Web Content...
Page 116: ...96 Chapter 6 Editing Pages...
Page 148: ...128 Chapter 7 Using Web Development Languages...
Page 190: ...170 Chapter 11 Deploying Files...
Page 210: ...190 Chapter 12 Testing and Maintaining Web Pages...
Page 216: ...196 Chapter 13 Extending the Help System...
Page 350: ...330 Glossary...
Page 358: ...338 Index...