| Setting |
Description |
| CF Data Source Name |
The data source name (DSN) used by ColdFusion to connect to the data source. |
| Database File |
The password required to connect to the data source. |
| System Database File |
If you want to secure access to the specified database file, click Browse Server to locate and enter a database that contains database security information. The system database is usually located in winnt\system32\system.mdw. |
| Use Default Username |
If selected, ColdFusion does not pass a user name or password when requesting a connection. The Microsfot Access driver uses the default user name and password. |
| Description |
(Optional) A description for this connection. |
| Default Username |
The user name that the driver uses to connect to the data source if an application requests a connection without supplying a username. |
| Default Password |
The password that the driver uses to connect to the data source if an application requests a connection without supplying a password. |
| 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. |
| Page Timeout |
The time (in tenths of a second) before a request for a ColdFusion page times out. |
| Max Buffer Size |
The total number of bytes that ColdFusion uses to cache application pages. Enter a value to optimize ColdFusion performance. |
| Connection String |
A field that passes database-specific parameters, such as login credentials, to the data source. |
| 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. The Timeout setting does not return a connection to the cache after a specified period of time, regardless of how infrequently it is used. The default is "" or 0, which means that the connection timeout is never enforced. |
| 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. |
