April 22, 2003 at 7:09 am
Greetings,
We just upgraded a development test server to SQL Server 2000 and then applied SP3. Following the upgrade we have experienced problems with updating tables that have default values (in all cases getdate()) associated with them. The error that comes up is "Row cannot be located for updating. Some values may have changed since it was last read.".
Interestingly the problem does not occur if you fire the update directly from Query Analyzer just when you run the update through Enterprise Manager or through web application.
Because of the scenario listed above I immediately thought MDAC but a reinstall of SP3 did not fix it (did not run a MDAC install seperate, should try this).
I found article 300586 on the MS site which describes the error perfectly however they do not reference SQL Server.
Curious if anyone has seen this and if so, what did you do to work around it. Let me know if you can provide any further direction or ideas.
TIA
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 23, 2003 at 7:13 am
Well, I thought that this was a problem associated with the upgrade however, the problem is actually with the type of connection string used by the code that worked fine in the previous version of SQL Server but not in 2000. Additionally, I had two problems that were so similar in nature that they appeared to be the same thing and I was misled (by my own foolishness) to combine them into one because we had just completed the upgrade.
Anyway, changing a connection string to the proper oledb type string fixes one of the problems and the other is a bad practice problem that I will work on the database design to fix.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply