MaxConnect
database parameter
Description
Sets the maximum number of simultaneous connections you want to
make when accessing a database.
The default is 25 simultaneous connections. You can override this
default by setting MaxConnect up to the maximum number of simultaneous
connections configured on the database server.
When to specify MaxConnect
You must specify a value for the MaxConnect parameter before
connecting to the database.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
DIR SAP DirectConnect
Syntax
|
1 |
MaxConnect=value |
|
Parameter |
Description |
|---|---|
|
value |
The maximum number of simultaneous connections you |
Default value
MaxConnect=25
Usage
DirectConnect, ASE, and SYC
MaxConnect sets the SAP Sybase CT-Lib connection property
CS_MAX_CONNECT to the number of simultaneous database connections you
specify for a single CT-Lib context.
Examples
To set the MaxConnect value to a maximum of 50 simultaneous
database connections:
-
Database profile
Type 50 in the Maximum Client Library Connections box (when
using the ASE or SYC interface) or the Maximum Connections For This
Context box (when using the DIR interface). This check box is on the
Network page. -
Application
Type the following in code:
1SQLCA.DBParm="MaxConnect=50"