Connecting to DB2 Universal Database
47
Guidelines for data sources
When you add data sources to ColdFusion MX, keep the following guidelines in mind:
•
Data source names should be all one word.
•
Data source names can contain only letters, numbers, hyphens, and the underscore character
(_).
•
Data source names should not contain special characters or spaces.
•
Although data source names are not case-sensitive, you should use a consistent capitalization
scheme.
•
Depending on the JDBC driver, connection strings and JDBC URLs might be case-sensitive.
•
Ensure that you use the Administrator to verify that ColdFusion MX can connect to the data
source.
•
A data source must exist in the ColdFusion MX Administrator before you use it on an
application page to retrieve data.
Connecting to DB2 Universal Database
This section discusses using the ColdFusion MX Administrator to define data sources for DB2
Universal Database (UDB). For information on defining data sources that work with DB2 for
OS/390 or iSeries, see
“Connecting to other data sources” on page 60
. To see a list of DB2
versions that ColdFusion MX supports, go to
www.macromedia.com/go/sysreqscf
.
Note:
DB2 UDB refers to all versions of DB2 running on Windows, UNIX, and Linux/s390
platforms.
Use the settings in the following table to connect ColdFusion MX to DB2:
Setting
Description
CF Data Source
Name
The data source name (DSN) used by ColdFusion MX to connect to the data
source.
Database
The name of the database.
Server
The name of the server that hosts the database that you want to use. If the
database is local, enclose the word
local
in parentheses.
Port
The number of the TCP/IP port that the server monitors for connections.
Username
The user name that ColdFusion MX passes to the JDBC driver to connect to the
data source if a ColdFusion application does not supply a user name (for
example, in a
cfquery
tag).
The user name must have CREATE PACKAGE privileges for the database, or
the database administrator must create a package. Consult the database
administrator when configuring this type of data source.
Password
The password that ColdFusion MX passes to the JDBC driver to connect to the
data source if a ColdFusion application does not supply a password (for
example, in a
cfquery
tag).
Description
(Optional) A description for this connection.
Содержание COLFUSION MX 7 - INSTALLING AND USING COLDFUSION...
Страница 1: ...COLDFUSION MX7 Configuring and Administering ColdFusion MX ...
Страница 6: ...6 Contents ...
Страница 10: ......
Страница 78: ...78 Chapter 4 Web Server Management ...
Страница 84: ...84 Chapter 5 Deploying ColdFusion Applications ...
Страница 102: ...102 Chapter 7 Using Multiple Server Instances ...
Страница 104: ......
Страница 108: ...108 Chapter 8 Introducing Verity and Verity Tools ...
Страница 164: ...164 Chapter 10 Using Verity Utilities ...