Kbase P36828: ASP not disconnecting from database can cause "Microsoft OLE DB Provider for ODBC Drivers (0x8000400
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/03/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[DataDirect-Technologies][ODBC PROGRESS driver]Optional feature not implemented.
No SQL servers are available. Try again later. (8839)
ASP (Active Server Pages) script contains multiple connections to the Progress database.
CAUSE:
Database connections are released only after the ASP script has finished executing. Even when each connection is explicitly closed it seems that individual connections are not released. This can result in (Microsoft) error 0x80004005 and Progress error 8839.
FIX:
Calculate the required number of connections (for both 4GL and SQL-92 clients) and start separate brokers for 4GL and SQL-92 clients.