BackUp LevelNext

About ColdFusion Data Sources

Before a database can be used with a ColdFusion application, it must be configured as a ColdFusion data source. You do this using the ColdFusion Administrator, Data Sources page. The specific databases you can configure for ColdFusion depend on the platform on which ColdFusion Server is installed and on whether you're running ColdFusion Server Workgroup, Professional, or Enterprise editions.

Databases supported by ColdFusion

ColdFusion uses ODBC to interact with data sources. In addition, two native database drivers are available for configuring Oracle 7.3 and 8.0 databases, and Sybase System 11 databases. However, not all ColdFusion Server editions support all database types. The following table describes database support in ColdFusion Server.

Databases Supported by ColdFusion 
ColdFusion Edition Databases Supported
Workgroup Desktop databases through ODBC:
  • Microsoft Access
  • Microsoft FoxPro
  • Inprise (Borland) dBase
  • Inprise Paradox
  • Lotus Approach
  • ASCII text
  • Microsoft Excel
Professional All ODBC data sources OLE DB data sources (Windows only)
Enterprise All ODBC data sources OLE DB data sources (Windows only) Sybase System 11 and Oracle 7.3 and 8.0 through native database drivers (Solaris and Windows NT)


BackUp LevelNext

allaire

AllaireDoc@allaire.com
Copyright © 1998, Allaire Corporation. All rights reserved.