Unanswered: query does not return actual row updates
We developed an application using VB6 and MS-SQLServer with an OLEDB connection. A client's site on which this application is running experiences some strange database problems. It looks like MSSQL does not always instantaneously updates the database and returns 'old' data.
For example: we perform a large update query using ADODB.Command, which is necessary for our next query using a ADODB.Recordset. The second query does not notices all the updates. Note: We use the same ADODB.Connection for both the update and the query.
It looks like this problem sometimes also occurs with single row-updates, but I'm unable to reproduce these problems on our development workstations.
Does anyone have a clue how and if this problem can happen and how to solve it?