Kbase 20800: SQL92 Client Hangs During Connection to a Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/21/2003 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Problems connecting via SQL92
SQL92 client hangs during a connection to a database.
Database is being started using _mprosrv.
_sqlsrv2 process spawns and uses almost 100% of the CPU.
SQL server process terminated. (8841)
CAUSE:
Starting the database using the executable _mprosrv instead of the script PROSERVE, can cause this connection problem for the SQL92 clients. The PROSERVE script configures many environment variables necessary to properly spawn the _sqlsrv2 process.
FIX:
To solve this problem, change the scripts to start the database from _mprosrv to PROSERVE.