User Guide

C HAPTER 4
Chapter 4 Managing Data Sources
ColdFusion facilitates the delivery of dynamic database content to the Web in a very
short time-frame Before you can use a database in a ColdFusion application, you
must register data source in the ColdFusion Administrator. This chapter is organized
by database type and connection type.
Contents
• About ColdFusion Data Sources ..................................................................... 78
• Choosing the Right Drivers ............................................................................. 80
• Adding Data Sources for ColdFusion.............................................................. 82
• Verifying ColdFusion Data Sources ................................................................ 85
• Connecting to Microsoft SQL Server Databases............................................ 87
• Connecting to OpenIngress Databases .......................................................... 90
• Connecting to dBase Databases...................................................................... 92
• Connecting to Microsoft Access Databases ................................................... 94
• Connecting to Microsoft Excel Databases...................................................... 96
• Connecting to ASCII Text Databases .............................................................. 97
• Connecting to Oracle 7.3/8.0 Databases........................................................ 98
• Connecting to DB2 Data Sources.................................................................. 105
• Connecting to Informix data sources ........................................................... 111
• Connecting to Sybase System 11 data sources ............................................ 117
• Using ColdFusion to Create a Data Source .................................................. 120