General information
Category:
Internet applications
Sergey,
I didn't set up the connection, but I'm thinking it's ODBC. This is the ASP connection code:
Set conn = Server.CreateObject("ADODB.connection")
conn.Open session("session_dsn")
where, I believe, session_dsn is the ODBC dsn connection name.
>Bill,
>
>Are you using OLE DB provider for ODBC or VFP OLE DB provider?
>
>>Hi All,
>>We get the following error for a second (or third) update using rs.update in ASP script connected to VFP database thru ADO.
>>
>>Error:
>>"Row cannot be located for updating. Some values may have been changed since it was last read."
>>
>>Hitting the browser refresh will send it through correctly, but that's a poor work-around :^)
>>
>>It's a problem with ADO's Query By Update method of creating an "Action query", which gets confused on the second rs.update to the same record. But how can the action query be controlled, or otherwise fixed?
>>
>>The SQL UPDATE mytable SET ... works great since it doesn't create an action query, but we have to use the QBU method to use AppendChunks, don't we?
>>
>>I hope somebody has solved this one - Thanks!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only