This setting allows you to define the maximum number of connections between a client and data source that can be simultaneously allocated by your application.
SQLMaxConnections = number
• number - The maximum number of concurrent connections allowed by your application between a client and the data source.
The TCP/IP package used determines the maximum number of connections allowed between a client and a server. If this setting isn’t used in the defaults file, the default value of 32 will be used. This is the maximum number of connections allowed by some TCP/IP packages.
|
Be sure to consult the documentation of the TCP/IP package used with your application. If the TCP/IP package allows less than 32 connections, be sure to set the SQLMaxConnections defaults file setting to the number of connections allowed by the TCP/IP package, or lower. The SQLMaxConnections setting should never exceed the number of connections allowed by that package. |
If a user reaches the maximum number of connections set for your application, a message will appear stating that the operation can’t be executed because the maximum number of connections has been reached. The application will remain open, and the user can try the operation again.
Because applications you create will rarely require more than five simultaneous connections, we recommend that you include this setting in your defaults file to set the maximum number of connections allowed by your application to less than 32. Lowering the setting is especially important if your application will be used simultaneously with other applications using TCP/IP, as each application will compete for the limited number of connections allowed by the TCP/IP package.