MACROMEDIA COLDFUSION 5-ADVANCED ADMINISTRATION, Manual

Page: 33 / 372

Connecting to DB2 Databases 15
Connecting to DB2 Databases
On Windows and UNIX, ColdFusion lets you access DB2 databases using ODBC and
native drivers.
Configuring DB2 options (Windows)
If you install ColdFusion on a Windows server, you can configure a DB2 database as a
ColdFusion data source using ODBC, OLE DB, or a native driver. For information
about using OLE DB with ColdFusion data sources, see “About OLE DB” on page 4.
Native driver: DB2 Universal Database 5.2/6.1 options (Windows)
The following table describes ColdFusion options for the DB2 Universal Database
5.2/6.1 native driver:
Note
Although native driver performance is usually superior to ODBC performance, you
can connect to DB2 via ODBC on Windows. To do so, create the data source in the
Windows ODBC Data Source Administrator, using the IBM ODBC driver. In the
ColdFusion Administrator, configure any ColdFusion-specific settings, such as a
username and password.
Configuring DB2 options (UNIX)
If you install ColdFusion Server Enterprise Edition on a Solaris or Linux server, you
can configure DB2 ColdFusion data sources using a native driver. On Solaris, you can
also use a MERANT ODBC driver.
Native driver: DB2 Universal Database 5.2/6.1 options (Solaris, Linux)
ColdFusion native drivers are the same for Windows NT and UNIX. For the
ColdFusion options for the DB2 Universal Database 5.2/6.1 native driver, see the
table in “Native driver: DB2 Universal Database 5.2/6.1 options (Windows)” on
page 15.
Option Description
Data Source Name A name for your data source.
Description Descriptive information about the data source.
Database Alias The DB2 database name.