update openquery("PCI2",'select ActualID,CostSUP,CostCompleted from smisdb24Feb2014.ctr_actual_delivery ') set CostSUP = 5 where ActualID = 65059
เมื่อรันแล้ว ได้ผล Error ดังนี้
OLE DB provider "MSDASQL" for linked server "PCI2" returned message "Row cannot be located for updating. Some values may have been changed since it was last read.".
Msg 7343, Level 16, State 4, Line 1
The OLE DB provider "MSDASQL" for linked server "PCI2" could not UPDATE table "[MSDASQL]". The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.
ไม่ทราบว่า Error ดังกล่าวเกิดจากอะไรหรอค่ะ มีใครพอแนะวิธีแก้ได้บ้าง
ปล."PCI2" คือชื่อ Link Server ค่ะ
ถ้าผิดห้องขออภัยนะค่ะ
Load balance : Server 02
