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.
Содержание COLDFUSION 5-ADVANCED ADMINISTRATION
Страница 1: ...Macromedia Incorporated Advanced ColdFusion Administration ColdFusion 5...
Страница 20: ......
Страница 56: ...38 Chapter 1 Advanced Data Source Management...
Страница 74: ...56 Chapter 2 Administrator Tools...
Страница 76: ......
Страница 86: ...68 Chapter 3 ColdFusion Security...
Страница 87: ...To Learn More About Security 69...
Страница 88: ...70 Chapter 3 ColdFusion Security...
Страница 130: ...112 Chapter 5 Configuring Advanced Security...
Страница 132: ......
Страница 154: ...136 Chapter 6 Configuring Verity K2 Server...
Страница 162: ...144 Chapter 7 Indexing XML Documents...
Страница 202: ...184 Chapter 8 Verity Spider...
Страница 236: ...218 Chapter 10 Verity Troubleshooting Utilities...
Страница 238: ......
Страница 348: ...330 Chapter 14 ClusterCATS Utilities...
Страница 349: ...Using sniff 331...
Страница 350: ...332 Chapter 14 ClusterCATS Utilities...
Страница 362: ...344 Chapter 15 Optimizing ClusterCATS...
Страница 372: ...354 Index...