Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Who really uses the VFPOleDB.1 provider?
Message
 
To
05/10/2006 19:32:13
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01158763
Message ID:
01160806
Views:
26
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform