Kbase P10907: losing Webspeed connection to a SQL databaseserver every nig
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/30/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows 2000
FACT(s) (Environment):
WebSpeed 3.1C
FACT(s) (Environment):
Webspeed order entry application opens a connection to a SQL
Server Database in the startup program using ActiveX Data Objects. The resulting
connection reference is stored in a global com-handle variable for use later on
as a parameter to several COM components (DLLs).
SYMPTOM(s):
losing Webspeed connection to a SQL databaseserver every night when SQL database is shut down and restarted
FIX:
Use the correct syntax to shut down and restart webspeed broker after the connection is lost