MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION..., Руководство пользователя

Страница: 106 / 350

84 Administering ColdFusion Server
coldfusion/bin
. For detailed information about editing the ColdFusion start script for
your particular database, see the section about your database in this chapter.
ColdFusion Settings
To define a number of advanced ODBC and ColdFusion options, select a data source
and click the CF Settings button. These options apply to all platforms. The following
table describes the ColdFusion data source options.
ColdFusion Data Source Settings
Option Description
Login Timeout The amount of time in seconds before ColdFusion times
out the connection login page.
Limit Connections Click to enable and then specify the number of
simultaneous connections you want to allow for the
current data source.
Note: If you enable Limit Connections without specifying a
limit for simultaneous connections, ColdFusion defaults to
unlimited connections.
ColdFusion Login Enter a username/password for accessing the ODBC data
source. Any username and password specified in a
CFQUERY or other data access tag overrides the values
specified in the ColdFusion login.
Also, when creating a data source using a native database
driver, you use the username and password options to pass
login information to the database.
Maintain database
connections Ordinarily, a connection to a data source is established for
every operation that requires it. However, you can improve
performance by caching the database connection. To do
so, click to enable this check box.
Disable Database
Connections Disables connections to the data source. This setting is
useful if you need to perform administrative tasks to the
database. ColdFusion no longer allows users to establish
new connections to the disabled data source. In addition,
any existing connections that are not in use are
automatically disconnected and cleaned up, and any
connections currently in use are automatically notified that
they are to clean themselves up as soon as their current
transaction is complete. Subsequent requests to disabled
data sources return trapable database exceptions.
To restore the connection to the data source, uncheck this
option.