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.