Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Who really uses the VFPOleDB.1 provider?
Message
 
À
05/10/2006 19:32:13
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01158763
Message ID:
01160806
Vues:
21
Hi Michael.
This may be completely off topic but I'll include my experiences anyway.

On a server app, when there was a lot of users simultaneously updating DBF's (part of a DBC) I was getting a lot of Dropped records (e.g. I had an append but the append never actually happened.
This was definitely traced to high simultaneuous file updating on the system
Eventually I ended up LOCKING every file before an append and unlocking it after the fields were populated.
This solved the problem ok !!!!

I know the OLEDB works in a differnet way but maybe there is some inherent problem i there

Regards,
Gerard




>>I wasn't really suggesting it as a full solution - I just thought it would be interesting to see the results if you converted your basic page that was giving errors to use a SPROC instead..
>
>I am testing that right now. I will let you know on the results.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform