User Guide

Chapter 1
Advanced Data Source
Management
This chapter describes how to create and configure ColdFusion data sources for
several databases using ODBC, OLE DB, and native drivers. It also describes how to
use ColdFusion to create a database file in a cfquery and how to use connection
string options.
For basic information on data sources and for information on how to connect to SQL
Server, Access, and Oracle databases, see Installing and Configuring ColdFusion
Server.
Contents
• About ColdFusion database drivers...........................................................................4
• Using ColdFusion to Create a Data Source (UNIX only)........................................10
• Using Connection String Options............................................................................ 12
• Connecting to DB2 Databases .................................................................................15
• Connecting to dBASE/FoxPro Databases................................................................21
• Connecting to Excel Databases................................................................................24
• Connecting to Informix Databases..........................................................................26
• Connecting to Sybase Databases.............................................................................32
• Connecting to Text Databases..................................................................................35
• Connecting to Visual FoxPro Databases..................................................................37