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.
ASE, SYC Sybase Adaptive Server Enterprise
DIR Sybase DirectConnect
MaxConnect=value
Parameter |
Description |
|---|---|
value |
The maximum number of simultaneous connections you want to make when accessing a database |
MaxConnect=25
DirectConnect, ASE, and SYC MaxConnect sets the Sybase CT-Lib connection property CS_MAX_CONNECT to the number of simultaneous database connections you specify for a single CT-Lib context.
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:
SQLCA.DBParm="MaxConnect=50"
