Kbase P142537: Getting Error From SQL Server DataServer Secondary connection problem, reverting to main connection.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/03/2009 |
|
Status: Unverified
SYMPTOM(s):
Getting error from SQL Server DataServer
Secondary connection problem, reverting to main connection.
FACT(s) (Environment):
Error is seen from dataserv.lg
Using default startup parameters
Windows
MS SQL DataServer
CAUSE:
The error indicates the application is running out of connections managed from connection pooling by ODBC driver
FIX:
Increase the number of connections in the managed connection pool by increase following DataServer startup parameter
-Dsrv PRGRS_CACHE_CONN,n
Where n is the number of managed connection. The default is 5.