|
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.
|
|
|
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)
|
|
|