A data source is a complete database configuration that uses a JDBC driver to communicate with a specific database. In Adobe ColdFusion, 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.

For basic information on data sources and connecting to databases, click Resources in the ColdFusion Administrator, and then select Getting Started Experience.

Contents

• About JDBC
• Adding data sources
• Connecting to Apache Derby Client
• Connecting to Apache Derby Embedded
• 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 PostgreSQL
• Connecting to Sybase
• Connecting to JNDI data sources