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.
Controls
-
ASE, SYC Sybase Adaptive
Server Enterprise -
DIR Sybase DirectConnect
Syntax
|
1 |
MaxConnect=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
The maximum number of simultaneous connections |
Default
MaxConnect=25
Usage
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.
Examples
To set the MaxConnect value to a maximum of 50 simultaneous
database connections:
-
Database
profileType
50in 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.DbParameter="MaxConnect=50"