Hi All,
I am using VFP6 and Visual Promatrix Enterprise 6.
I have developed a number of applications with SQL Server 2000 at the
backend.
One of my applicataion has 75 users who log on simultaneously. I have
started experiencing a problem with SQL Server. Randomly, one user BLOCKS a
table.
If u go into SQL Server Enterprise Manager and into MANAGEMENT/CURRENT
ACTIVITY/LOCKS, one user is BLOCKING a lot of other users.
The BLOCKING user may not have any form open. He had entered some data and
then closed the form. Now, the BLOCKING does not release till he exits the
application.
This phenomenon occurs when he hits the SAVE button on the toolbar. After
that this BLOCKING occurs. It is random. May not happen the whole day and
may happen three to four times a day. But then the table that is LOCKED, is
not available to anybody else and their system hangs.
Anybody else also faced this problem? I think this happens when VPM does not
release a TRANSACTION. I may be wrong.
I have been working with VFP6 and SQL Server 6,7,2000. but did not face this problem there. It only happens in VPM.
Would appriciate a quick reply as some of the users are now fed up of
CTRL+ALT+DELing out of their application.
TIA
Abdul Ahad
CSi
www.csi-pk.com