Data Source Management

A data source is a complete database configuration that uses a JDBC driver to communicate with a specific database. In Macromedia ColdFusion MX 7, you must configure a data source for each database that you want to use. After you configure a data source, ColdFusion can then communicate with that data source through JDBC.

This chapter describes the configuration options for ColdFusion MX 7 data sources. For basic information on data sources and connecting to databases, see Getting Started Building ColdFusion MX Applications.

Contents

About JDBC

Adding data sources

Connecting to DB2 Universal Database

Connecting to Informix

Connecting to Microsoft Access

Connecting to Microsoft Access with Unicode

Connecting to Microsoft SQL Server

Connecting to MySQL

Connecting to ODBC Socket

Connecting to Oracle

Connecting to other data sources

Connecting to Sybase

Connecting to JNDI data sources