Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View - Connection is Busy
Message
De
24/11/2004 08:32:51
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
 
 
À
24/11/2004 06:07:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
00960626
Message ID:
00964234
Vues:
15
No, I got an article from someone about it but I don't remember where it is and who sent me it. However I think so all terminals shouldn't lock about one terminals problem.

>>I had created a fetched grid. Sometimes there was too many records being on grid so fetch wasn't ending. User was trying append new record when that time. All machines on SQL server was locking. After that I prevented fetch and my problem solved.
>
>I think there is a bug here.
>
>>
>>>>SQL server process your commands in a queue. if you use a server side fetch, your select command not ended until you end the fetch. If you try another sql command with same handle you'll see your server's all station will locked!.. It's strange but, true. It had reasoned me a big trouble. I can't forget my scary movie. :)
>>>
>>>Can you post a sketch of code ?
>>>Thanks
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform