ColdFusion uses Open DataBase Connectivity (ODBC), OLE DB, and native database drivers to interact with data sources. However, not all ColdFusion Server editions support all database drivers. ColdFusion Professional edition is limited to ODBC on Linux and to ODBC and OLE DB on Win32. The following table shows the available drivers for each ColdFusion edition:
Functionality |
Library name |
Vendor |
Version |
Windows 98 |
Windows NT |
Linux1 |
Solaris |
HP-UX |
---|---|---|---|---|---|---|---|---|
ODBC |
||||||||
Btrieve |
DataDirect Connect ODBC |
MERANT |
3.7 |
P2 |
P |
|||
FileMaker |
FileMaker |
5.0 |
P |
P |
||||
dBASE/FoxPro |
DataDirect Connect ODBC |
MERANT |
3.7 |
P |
P |
P |
E |
E |
IBM DB2 UDB3 |
DataDirect Connect ODBC |
MERANT |
3.7 |
E |
E |
E |
E |
|
Informix 7.x/9.x4 |
DataDirect Connect ODBC |
MERANT |
3.7 |
E |
E |
E |
E |
|
Informix Dynamic Server for Informix 9.x |
DataDirect Connect ODBC |
MERANT |
3.7 |
E |
E |
E |
E |
|
Microsoft SQL Server |
DataDirect Connect ODBC |
MERANT |
3.7 |
P |
E |
E |
||
MySQL5 |
DataDirect Connect ODBC |
MERANT |
3.6 |
P |
E |
E |
||
Oracle 7.3.4 |
DataDirect Connect ODBC |
MERANT |
3.7 |
E |
E |
E |
||
Oracle 8 |
DataDirect Connect ODBC |
MERANT |
3.7 |
E |
E |
E |
E |
E |
Paradox |
DataDirect Connect ODBC |
MERANT |
3.7 |
P |
P |
|||
Progress 7.2 |
DataDirect Connect ODBC |
MERANT |
3.7 |
E |
||||
SQLbase 6.x |
DataDirect Connect ODBC |
MERANT |
3.7 |
E |
E |
|||
Sybase 11 - Sybase Adaptive Server 12.0 |
DataDirect Connect ODBC |
MERANT |
3.7 |
E |
E |
E |
E |
E |
Text |
DataDirect Connect ODBC |
MERANT |
3.7 |
P |
P |
P |
E |
E |
dBASE |
MDAC |
Microsoft |
P |
P |
||||
Microsoft Access |
MDAC |
Microsoft |
P |
P |
||||
Microsoft Excel |
MDAC |
Microsoft |
P |
P |
||||
Microsoft FoxPro |
MDAC |
Microsoft |
P |
P |
||||
Microsoft SQL Server |
MDAC |
Microsoft |
P |
P |
||||
Microsoft Visual FoxPro |
MDAC |
Microsoft |
P |
P |
||||
Text |
MDAC |
Microsoft |
P |
P |
||||
Native |
||||||||
IBM DB2 |
Macromedia |
5.2.0 |
E |
E |
E |
E |
||
IBM DB2 |
Macromedia |
6.1 |
E |
E |
E |
E |
E |
|
Informix |
Macromedia |
7.x, 9.x |
E |
E |
E |
E |
E |
|
Oracle 7.3.4 |
Macromedia |
7.3.0 |
E |
E |
E |
|||
Oracle 8.0 |
Macromedia |
8.0.4.0.0, 8i |
E |
E |
E |
E |
E |
|
Sybase |
Macromedia |
System 11, 12 |
E |
E |
E |
E |
E |
|
OLE DB |
||||||||
Microsoft.Jet.ODBC (8.0.4.0.0 client libraries) |
MDAC |
Microsoft |
4.0 |
P |
P |
|||
SQLOLEDB (7.3.3 client libraries) |
Microsoft |
7.3.0 |
P |
P |
1 ColdFusion 5 supports Red Hat Linux 6.2 and 7.0, SuSE Linux 7.0, Cobalt RAQ3, XTR, and RAQ4 Linux. 2 P= ColdFusion Professional Edition; E= ColdFusion Enterprise Edition. 3 DB2 for Windows NT and DB2 Common Server requires either IBM DB2 Client Application Enabler for Win32 version 2.1 or later, or IBM DB2 Software Development Kit for Win32 version 2.1 or later. DB2 for Solaris or HP-UX requires version 2.12 or later. 4 Informix for Windows requires version 2.5 or later of either the Informix-Connect for Windows or the Informix Software Developer's Kit for Windows. Informix for Solaris and HP-UX requires Informix-Client Software Developer's Kit version 2.5 or later for UNIX. 5 For UNIX, the MySQL driver provided with MyODBC will work. This driver displays in the drop-down list if it is located at /opt/coldfusion/lib/libmyodbc.so (.s1 for HP-UX). |
To use an existing database with your ColdFusion applications, you need to register or create the data source using the ColdFusion Administrator. If you are using a DB2, Informix, Oracle, or Sybase database and want to take advantage of the ColdFusion native drivers, you also need to install and configure database client software.
The remaining sections in this chapter provide details about configuring ColdFusion data sources for Microsoft SQL Server, Microsoft Access, and Oracle databases. To learn how to connect to other databases, see Advanced ColdFusion Server Administration.
The following sections apply to all databases and operating systems:
Section and location |
Description |
---|---|
"Choosing the Correct Drivers" on page 116 |
Describes the different types of drivers you can use to access data sources with ColdFusion Server (ODBC, OLE DB, and native) and helps you decide which driver best suits your needs. |
"Adding Data Sources for ColdFusion" on page 117 |
Provides step-by-step instructions for using the ColdFusion Administrator to add a data source. These instructions apply to all platforms and drivers. |
"Verifying ColdFusion Data Sources" on page 123 |
Provides step-by-step instructions for making sure that a data source has been correctly configured and is available to your ColdFusion application pages. |