Kbase 21834: SQL-92: Dual Progress Installations & Error -219901. (8933)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/25/2002 |
|
SUMMARY:
This Knowledge Base Solution relates to Progress 9.1x and 8.3x installed on the same Windows machine. Other dual versions and configurations might also apply.
When trying to connect to a database using SQL-92 you might see the following SQL exception message:
"-219901. (8933)"
After several tries, the following error message might also appear:
"Exceeding permissible number of connections (8933)"
EXPLANATION:
This is the result of having DLC and PATH environment variables pointing to a previous version. Each time a connection attempt is made, a _sqlsrv2 process is spawned. In turn, this will result in the second error message.
SOLUTION:
1) Remove the DLC and PATH environment variables, restart the server
and 9.1x should work fine. Depending on your setup, Version 8.3x
should still work by reading the DLC value from the registry
entries or ini files. Pointing these variables to the
9.1x installation will also work, but it might cause trouble for
the 8.3x installation.
2) Start your database with the PROSERVE (not _mprosrv) command
through Proenv instead of the Progress Explorer.
References to Written Documentation:
Progress Knowledge Base Solutions:
20415, "Exceeding Permissible Number of Connections (8933)"
19044, "Exceeding Permissible Number of Connections: SQL-92"
21552, "Progress SQL-92 Server - Common Issues and How To Avoid Them"