Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Blocking issue using MS SQL Server
Message
De
11/09/2004 23:59:58
 
 
À
09/09/2004 03:12:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual ProMatrix
Divers
Thread ID:
00940503
Message ID:
00941415
Vues:
16
>Hi all,
>
>I am using Visual Promatrix at frond end and MS SQL Server at backend. I have developed Client/Server multi user application using these technologies. I am experiencing table blocking using these tools. Can anybody provide any help to avoid this bug.
>Any help will be appreciated.
>
>Thanks in advance.


Hullo Mo - how have you been ?
I can't speak of VPM, but -
if you have some blocking problem that was generated via Visual FoxPro into MS-SQL Server ?

then you need to study 'what' that process is
in the User Manager in the Enterprise Manager thingie, in real time, as the block *IS* occurring.
you don't mention WHICH version of MS-SQL you are using -
the techniques to track / view 'that' blocking process vary by version.


In the meantime, though -

what the heck is 'your program' doing during and just prior to the deadlock?
update? insert ? delete ? firing a stored procedure? whats going on ?

can you be a tad more specific ???

je qu yu [Bill]
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform