MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER, Manual

Page: 130 / 160

118 Chapter 6 Managing Data Sources
Installing and Configuring ColdFusion Server
Note
You may have to supply a username and password for data sources that you want
to verify. To define a username and password for a data source, edit the data
source properties.
If you are creating a UNIX data source, you may have to set environment variables
for your database client library by editing the ColdFusion start script in <installdir>/
coldfusion/bin. For more information on editing the ColdFusion start script for your
particular database, see Advanced ColdFusion Server Administration.
ColdFusion Settings
To define a number of advanced ODBC and ColdFusion settings in the ColdFusion
Administrator, select a data source and click CF Settings . The settings apply to all
platforms. The following table describes the ColdFusion data source settings:
Setting Description
Login Timeout The number of seconds before ColdFusion times out the
database connection login attempt.
Limit Connections Select this check box, then specify the number of
simultaneous connections 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 and 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.
When you create a data source using a native database
driver, you use the username and password options to pass
login information to the database.
•
Disable database connections Disables connections to
the data source. Use this setting to perform administrative
tasks with the database. You cannot establish new
connections to a disabled data source. ColdFusion
automatically disconnects and cleans up idle connections.
ColdFusion notifies any connection currently in use to
clean itself up when the current transaction is complete. To
restore the connection to the data source, clear this check
box.
•
Maintain database connections ColdFusion
establishes a connection to a data source for every
operation that requires it. To improve performance by
caching the database connection, select this check box.
install.book Page 118 Thursday, May 10, 2001 12:59 PM