Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPOleDb.1, the day after
Message
From
08/10/2006 13:24:13
 
 
To
08/10/2006 10:28:39
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01160349
Message ID:
01160403
Views:
14
>>You might think about checking another angle: from the above you have approx. 0.1% error on all SQL commands (16 errors on 600 * 25 SQL), so the probability of having the SQL error out again is at every thousandth error. Running the test for an hour should give you about 500 errors or a 50% chance of having the same SQL fail twice in a row. If you run your test for a few days on a dedicated machine you could make sure if the error always occured on the first SQL or if it occurs in the same percentage of "first errors". (Hypothesis: some trouble while creating/initializing).
>
>Yes, correct, when I ran more tests, at one occurence, it took 3 tries before the attempt was a success. But, again, on the user side, it was ok. I also dropped the number of occurences to 4 and increased the delay to 0.5 second.

Too bad - this probably means the error can hit you anytime. Running the few lines from OleAddapter creation over .Fill as a critical section might is the only thing left I can think of - and I doubt it could be that simple.

good luck

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform