We have found a strange problem when upgrading our application to SQL2005 from 2000
We have a web application which is extensively using disconnected
recordsets. In some cases when we update the recordset in the code it will
fail. Note this is not when the recordset is reconnected but when it is
updated so we are not going back to the server when it fails, but when
setting a new value to a field.
So the problem must be that the recordset created is different in SQL2000
than in an SQL2005.
We looked at the recordset object and compared the working and non working
recordsets. The only difference we can see is in the fields that "attributes"
is 120 when it works (sql2000) and 112 when it fails (sql2005).
Help in pointing us in the right direction to solve this would be greatly
appreciated.
--
James C.