Kbase P23133: New SQL92/ODBC connection fails with Exceeding permissible number of connections
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/08/2004 |
|
Status: Verified
FACT(s) (Environment):
OpenEdge 10.0A
FACT(s) (Environment):
Progress 9.1X
SYMPTOM(s):
Exceeding permissible number of connections
Exceeding permissible number of connections (8933)
Exceeding permissible number of connections (7625)
Exceeding permissible number of connections (7492)
Description [DataDirect Technology][ODCB Progress drive][Progress] Exceeding permissible number of connection
New ODBC Connections refused with error - Exceeding number of permissible connections (8933)
New SQL-92 Connections refused with error - Exceeding number of permissible connections (8933)
SQLState=HY000
ErrorCode=-20225
CAUSE:
4GL clients used all the available servers on the main broker
FIX:
Add a secondary broker for the SQL92/ODBC connections.