Connecting to Informix
49
Connecting to Informix
To see a list of Informix versions that ColdFusion MX supports, go to
www.macromedia.com/go/sysreqscf
. Use the settings in the following table to connect
ColdFusion MX to Informix data sources:
LongText Buffer
(chr)
The default buffer size, used if the CLOB option is not selected. The default
value is
64000
bytes.
BLOB Buffer
(bytes)
The default buffer size, used if the BLOB option is not selected. The default
value is
64000
bytes.
Allowed SQL
The SQL operations that can interact with the current data source.
Setting
Description
CF Data Source
Name
The data source name (DSN) used by ColdFusion MX to connect to the data
source.
Database
The database to which this data source connects.
Informix Server
The name of the Informix database server to which you want to connect.
Server
The name of the server that hosts the database. 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).
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.
Connection
String
A field that passes database-specific parameters, such as login credentials, to
the data source.
Limit
Connections
Specifies whether ColdFusion MX limits the number of database connections for
the data source. If you enable this option, use the Restrict Connections To field to
specify the maximum.
Restrict
Connections To
Specifies the maximum number of database connections for the data source. To
use this restriction, you must enable the Limit Connections option.
Maintain
Connections
ColdFusion MX establishes a connection to a data source for every operation
that requires one. Enable this option to improve performance by caching the data
source connection.
Max Pooled
Statements
Enables reuse of prepared statements (that is, stored procedures and queries
that use the
cfqueryparam
tag). Although you tune this setting based on your
application, start by setting it to the sum of the following:
•
Unique
cfquery
tags that use the
cfqueryparam
tag
•
Unique
cfstoredproc
tags
Setting
Description
Summary of Contents for COLFUSION MX 7 - INSTALLING AND USING COLDFUSION...
Page 1: ...COLDFUSION MX7 Configuring and Administering ColdFusion MX ...
Page 6: ...6 Contents ...
Page 10: ......
Page 78: ...78 Chapter 4 Web Server Management ...
Page 84: ...84 Chapter 5 Deploying ColdFusion Applications ...
Page 102: ...102 Chapter 7 Using Multiple Server Instances ...
Page 104: ......
Page 108: ...108 Chapter 8 Introducing Verity and Verity Tools ...