MaxConnect

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

DIR Sybase DirectConnect
SYC Sybase Adaptive Server Enterprise

Syntax

MaxConnect = value

Parameter	Description
value	The maximum number of simultaneous connections you want to make when accessing a database

Default

MaxConnect = 25

Usage

DirectConnect 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

Example 1

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 SYC interface) or the Maximum Connections For This Context box (when using the DIR interface). This check box is on the Network tab.
Application Type the following in code:
```
SQLCA.DBParm="MaxConnect=50"
```