Progress OpenEdge Database Connection Modes

We can connect to the OpenEdge Database in Single user mode or Multi user user mode.In single user mode database can be accessed by one user at a time.

Multi user mode database can be accessed in different ways and multiple user can access the database

at a time or simultaneously.

Different Connection Mode:-

• Single-user Mode
• Multi-user Mode
• Batch Mode
• Interactive Mode

Single-user Mode:

Running an OpenEdge database in Single-user mode allows only one user to access specified database at a time. Database cannot permit to connect a user form a different Progress session if another user is already accessing the database. Database engine maintain a lock file (.lk) to lock out other users from making connecting to the database

Multi-user Mode:

Running an OpenEdge database in Multi-user mode allows simultaneous access of the database to more than one user. All the database connection requests are coordinated by the broker, and servers retrieve and store data on behalf of the clients to the database.

Batch Mode:

Running a client in Batch mode allows processing on OpenEdge database without any user interaction. Batch mode is suitable for large scale database updates or procedures that require to run unattended. We can run both single-user and multi-user processes in batch modes.

Interactive Mode: (Direct Access Mode)

Running a client in Interactive mode allows the user to interact directly with an application connected to the database. We can run both single-user and multi-user processes in Interactive or Direct access mode.