Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Major mixup in two ASP.NET transactions
Message
From
25/09/2006 04:45:46
 
 
To
25/09/2006 01:31:55
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01150471
Message ID:
01156847
Views:
63
Hi Michel,

I've just read through the thread to date. The problem does seem to be that you are somehow (*sometimes*) using a connection referenced at the global level (given that you have no shared properties).

And if that is true then it is possible that Steven's suggestion as to the cause of the SQL errors is valid - if when you open a connection you then set the environment another hit that references the same connection might use it before that setup is complete.

Are the connections always created by your oProcess object? Are there *any* references to connections held in or referenced from oApp?

As a debug exercise you might add a GUID property to your connection class and log this before some of the offending error lines. This should enable you to check whether different hits were actually accessing the same connection and, if so, might also provide a clue as to where this was happening...?

HTH,
Viv






>> Is it concerned to case-sensitivity of SQL collate?
>
>The code is already as is as per the SQL syntax. And, if it would be the case, this means the SQL commands, where that would apply, would not run at all. In my case, it works until a simultaneous hit occurs.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform