User Guide

Table Of Contents
Chapter 6
Managing Data Sources
ColdFusion allows you to rapidly develop dynamic Web applicationsthat is,
applications that interact with databases. Before you can use a database in a
ColdFusion application, you must register the data source in the ColdFusion
Administrator. This chapter describes how to create and configure ColdFusion data
sources for SQL Server, Access, and Oracle databases. For details on how to configure
data sources for other databases, see Advanced ColdFusion Server Administration.
Contents
About ColdFusion Data Sources............................................................................ 110
Supported Database Drivers..................................................................................111
Choosing the Correct Drivers.................................................................................114
Adding Data Sources for ColdFusion.....................................................................115
Verifying ColdFusion Data Sources .......................................................................120
Connecting to Microsoft SQL Server Databases...................................................121
Connecting to Microsoft Access Databases..........................................................123
Connecting to Oracle Databases............................................................................127
install.book Page 109 Thursday, May 10, 2001 12:59 PM