Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPOleDb.1, part III
Message
From
26/10/2006 13:29:34
 
 
To
23/10/2006 08:58:01
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01162037
Message ID:
01164768
Views:
18
>>More bad news - I can get errors on NET1.1 as well as .NET2.0
>
>Similar error percentage or a different level ?
>IAC, that takes care of any adventurous ideas chaining different runtimes together for write statements <g>.
>What happens if you use the older versions of vfpOleDB.Dll, especially the one from vfp8 ?
>

Haven't had a chance to try that yet. I'll dig up a copy when I get time.

>is there a clear trend visible from the number of threads involved (and if so, equally strong in 1.1 vs 2.0) ?

Pretty similar error counts in both 1.1 and 2 under the same loadings and the error count increases roughly in proportion to the number of threads spawned on the client.

>As you may remember, one of the things I spouted off was to use the sys() for defining a critical section,
>but that does not seem to be supported by VfpOLEDB :-(.
>
>Any attempts to implement something similar via recordlocking through OleDB-SP will probably
>kill scalability right off (if not errorprone as well<g>), but perhaps some "isolation" can
>be implemented via .Net.

I tried putting a lock() around the whole web method in .NET but still got the same error count. Found that a bit odd - maybe I'd better test again...

>
>OTOH some input from MS probably can cut down to the core of the problem faster <g>.
>
Absolutely. I suggested to Michel a while ago that he opened a support incident with MS.....

Best,
Viv
Previous
Reply
Map
View

Click here to load this message in the networking platform