I have about 30 client applications located all over Canada and United States.
The client written in VB .NET accesses a .NET WebService. It creates object from the Proxy of the WebService, fills them with values, then send them the WebService through a web method.
In this web method, the WebService enters the data into the database.
The problem occurs when to people calls that web method at the same time. The values in the object passed to the web method gets mixed. Caller A will often see data from caller B.
Everything works on SSL, and the code is pretty simple. I cannot explaining how the data can be mixed between threads.
It's not a database problem, the log files indicate that the data is erroneous even before reaching the Insert statement.
Can someone help me.