Kbase P24572: Getting errors 748 & 9234 when attempting to connect more than 5 clients to schema holder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/18/2010 |
|
Status: Verified
SYMPTOM(s):
Getting errors 748 & 9234 when attempting to connect more than 5 clients to schema holder
The server or the system has no more resources. Try a larger -n. (748)
No servers are available. Try again later. (1154)
Personal DB server cannot support more than <5> users. (9234)
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.0x
Schema holder is being started with the proserve command.
Schema holder is being started via ProControl process.
Schema holder is built using the DataServer license
All Supported Operating Systems
Progress 9.x
ODBC DataServer
MS SQL DataServer
CAUSE:
The MS SQL Server and ODBC DataServer products are currently installed with Personal Database component. This means that any schema holder that is created with the SQL Server and ODBC DataServer licenses can allow up to only 5 client connections when the schema holder is being started with the proserve command.
FIX:
You can install the Workgroup Database license in addition to MS SQL Server and/or ODBC DataServer license, if you require the schema holder to be started with the proserve command or the ProControl utility, thus allowing for more client connections.
To by-pass the user count issue, you can connect to the schema holder with the -RO option. This will allow unlimited users to access the schema holder. However in this case, you would not be able to use proserve command or the ProControl utility to start the schema holder in a multi-user mode. Simply connect the progress client with -RO startup parameter.
prowin32 dbname -RO
_progres dbname -RO