![]() ![]() ![]() |
||
|
To see a list of Sybase versions that ColdFusion MX supports, go to www.macromedia.com/go/sysreqscf. Use the settings in the following table to connect ColdFusion MX to Sybase data sources:
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. |
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. This name must be either a fully qualified domain name (resolvable through DNS) or an IP address. It cannot be a netbios name (even if you are running NBT), or an alias you set up using the client connectivity wizard (both of these approaches worked in earlier ColdFusion versions). |
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 |
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 |
Description |
(Optional) A description for this connection. |
Connection String |
A field that passes database-specific parameters, such as login credentials, to the data source. |
Select Method |
Determines whether server cursors are used for SQL queries.
|
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
|
Timeout (min) |
The number of minutes that ColdFusion MX maintains an unused connection before destroying it. |
Interval (min) |
The time (in minutes) 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 MX 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 not selected, ColdFusion MX retrieves the number of characters 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 not selected, ColdFusion MX retrieves the number of characters specified in the BLOB Buffer setting. |
LongText Buffer |
The default buffer size; used if Enable Long Text Retrieval(CLOB) is not selected. The default value is |
BLOB Buffer |
The default buffer size; used if the BLOB option is not selected. The default value is |
Allowed SQL |
The SQL operations that can interact with the current data source. |
|
||
![]() ![]() ![]() |