ADO, SQL SVR, windows 2003 R1 and R2

[wadey]

Has anyone come across the following bug before:-

we have 2 servers, one running Windows 2003 release 1, and the other running Windows 2003 release 2. Using VB6 and ADO to connect to SQL Server 2000.

This VB code only works on Release 1:-

frm.AdodcTemp.Refresh
frm.AdodcTemp.RecordSet.Update

Where as the above code only works on Release 2 when put like this:-

frm.AdodcTemp.RecordSet.Update
frm.AdodcTemp.Refresh

Just doesnt make sense. Anyone come across ADO errors (Probably more like lower level problems) of this type before ? We're using MDAC 2.8 on all.

 

[Andrzejek]

When it does not work, what does it do?
Any errors? If so, which line does it error on?


Have fun.

---- Andy

 

[wadey]

running this code against release 1 produces the following error:-

frm.AdodcTemp.RecordSet.Update
frm.AdodcTemp.Refresh


error:-

Row cannot be located for updating. Some values may have been changed since it was last read.