>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