| Setting |
Description |
| CF Data Source Name |
The data source name (DSN) used by ColdFusion to connect to the data source. |
| Database |
The database to which this data source connects. |
| 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 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 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. |
| Select Method |
Determines whether server cursors are used for SQL queries.
The Direct method provides more efficient retrieval of data when you retrieve record sets in a forward-only direction and you limit your SQL Server connection to a single open SQL statement at a time. This is typical for ColdFusion applications.
The Cursor method lets you have multiple open SQL statements on a connection. This is not typical for ColdFusion applications, unless you use pooled statements. |
| Maintain Connections |
ColdFusion 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. |
| Timeout (min) |
The maximum number of minutes after the data source connection is made that you want ColdFusion to cache a connection after it is used. |
| Interval (sec) |
The time (in seconds) that the server waits between cycles to check for expired data source connections to close. |
| Disable Connections |
If selected, suspends all client connections. |
| Login Timeout (sec) |
The number of seconds before ColdFusion times out the data source connection login attempt. |
| CLOB |
Select to return the entire contents of any CLOB/Text columns in the database for this data source. If unchecked, ColdFusion retrieves the amount specified in the Long Text Buffer setting. |
| BLOB |
Select to return the entire contents of any BLOB/Image columns in the database for this data source. If unchecked, ColdFusion retrieves the amount specified in the Blob Buffer setting. |
| LongText Buffer (chr) |
The default buffer size, used if Enable Long Text Retrieval(CLOB) is not selected. Default is 65000 bytes. |
| BLOB Buffer (bytes) |
The default buffer size, used if Enable binary large object retrieval (BLOB) is not selected. Default is 65000 bytes. |
| Allowed SQL |
The SQL operations that can interact with the current data source. |
