>This would suggest that perhaps W2000 is sharing connections/file handles and when the holder on the connection logs out he drags others along and they lose their connection to the database.
>
>Can anyone enlighten me on this issue?
Spot on, that's what we found in Win2K. And here is the MS fix:
---------------
The following RegKeys did however resolve the problem:
Changes:
On the Windows 2000 sp2 Terminal Servers we added the following registry
Keys:
HKLM\System\CCS\Services\Mrxsmb\Paremeters
OpLocksDisabled
DWORD: 0x1
HKLM\System\CCS\Services\LanmanServer\Parameters
CachedOpenLimit
DWORD: 0x0
HKLM\System\CCS\Services\LanmanWorkstation\Parameters
UtilizeNTCaching
DWORD: 0x0
HKLM\System\CCS\Services\RDR\Paremeters
UseWriteBehind
DWORD: 0x0
On the Windows 2000, sp2 File Server which hosts the FoxPro 6
Application we added the following registry keys:
HKLM\System\CCS\Services\LanmanServer\Parameters
EnableOpLocks
DWORD: 0x0
HKLM\System\CCS\Services\LanmanServer\Parameters
CachedOpenLimit
DWORD: 0x0
HKLM\System\CCS\Services\LanmanWorkstation\Parameters
UtilizeNTCaching
DWORD: 0x0