Progress
Client Deployment
Guide


Connection Denials When the User Count Is Exceeded

When a user attempts to connect to a database using either a CONNECT statement or a command and exceeds the maximum number of users allowed to connect to the database, as specified with the Number of Users (-n) startup parameter, Progress denies the connection request and displays an error message. Progress also records the connection denial in the database log file.

Figure 2–1 shows a connection denial when a connection request exceeds the maximum number of users. In this example, the Number of Users (-n) startup parameter allows a maximum of three user connections. When the fourth user attempts to connect, Progress denies the connection.

Figure 2–1: Connection Denial When the User Count Is Exceeded

When Progress denies a user connection because the maximum number of users is exceeded, you must terminate an existing connection before the user can establish a new connection.

You can use database usage reporting features to track user connections to databases. For information about database usage reporting features, see the Progress Database Administration Guide and Reference and either the Progress Installation and Configuration Guide Version 9 for Windows or the Progress Installation and Configuration Guide Version 9 for UNIX.

For more information about the Number of Users (-n) startup parameter, see the Progress Startup Command and Parameter Reference.

For information about coding applications to handle connection denials, see the Progress Programming Handbook.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095