Sets the maximum number of simultaneously open DBPROCESS structures.
RETCODE dbsetmaxprocs ( SHORT maxprocs );
where
SUCCEED if the function call is successful, or else FAIL (that is, maxprocs <= 0).
A DB-Library application has a maximum number of simultaneously open DBPROCESS structures. Although the default number is 25, the application can change it by calling dbsetmaxprocs.
Similarly, the program can find out what the current limit is by calling dbgetmaxprocs.
The following table shows platform-dependent connection limitations:
| Operating system |
Maximum number of connections per workstation |
|---|---|
| Windows | 45 for all SQL Server running applications |
| MS-DOS | 15 |