>Just to say I haven't had much time to dig any deeper but I still cannot get any error with NET1.1/IIS5 and can't prevent the errors on NET2/IIS6. The slower server (with 1.1) maxes out at about 10 concurrent threads but at that level is handling about the same number of hits (40+/sec) as the NET2 version. No errors on NET1.1 and around 10/min on NET2.
>
>I gradually pushed the NET2 server up to 125 hits/sec at which point it was generating abour 50 errors/min - so about the same ratio of errors to hits applied.
>
>It looks as if all the VFP errors result from misreading the DBC - the errors were all either 'Database is invalid' or of the 'field not found' type.
The various types of errors I encountered so far in regards to this are:
Command contains unrecognized phrase/keyword.
SQL: Column 'FieldNameHere' is not found.
Function name is missing ).
Index does not match the table. Delete the index...
Variable 'FieldNameHere' is not found.
Syntax error.