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
Syntax
MaxConnect=value
|
Parameter |
Description |
|---|---|
|
value |
The maximum number of simultaneous connections you want to make when accessing a database |
Default value
MaxConnect=25
Usage
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). This check box is on the Network page.
-
Application
Type the following in code:
SQLCA.DBParm="MaxConnect=50"
