Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Major mixup in two ASP.NET transactions
Message
De
02/10/2006 04:58:00
 
 
À
01/10/2006 20:39:42
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01150471
Message ID:
01158492
Vues:
66
>>There's still the option I suggested a while ago - give each connection a GUID when it's created and look for cases where the same connection is used by more than one hit?
>
>I have eliminated the fact that this could be caused by reserved words. I adjusted for most of the places where that applied. But, this was not the source of the problem. I ran a stress test tonight by launching four simultaneous processes against the server at every second. The result was a total disaster. I got about 26 errors per minute. It is always the same types of errors. Here is the list of the types of erros:
>
>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.

The common denominator seems to be that all the errors are from the OLEDB provider. If the errors stemmed from multiple page based objects using global functions then I'd expect to see some errors that were not VFPOLEDB related (but that's just an assumption - maybe your oApp has few functions that are not ADO related - and those may suffer corruption without error).

Anyway, see my reply to your subsequent post.
Regards,
Viv
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform