error while upfdating linked server
-
Hi,
I am facing an error while updating a table of a linked server with values from my local server. My query runs like this :
UPDATE Network.linkedsvr.dbo.CodeMaster
SET chCodeCode = b.chCodeCode
chCodeDescription = b.chCodeDescription,
FROM Network.linkedsvr.dbo.CodeMaster a, CodeMaster b
WHERE a.nmId = b.nmId
The error it gives is :
Could not open table '"linkedsvr"."dbo"."CodeMaster"' from OLE DB provider 'SQLOLEDB'. The provider could not support a row lookup position. The provider indicates that conflicts occurred with other properties or requirements.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IOpenRowset:
penRowset returned 0x80040e21: [PROPID=DBPROP_BOOKMARKS VALUE=True STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_COMMANDTIMEOUT VALUE=16000 STATUS=DBPROPSTATUS_OK], [PROPID=Unknown PropertyID VALUE=True STATUS=DBPROPSTATUS_OK], [PROPID=DBPROP_IRowsetLocate VALUE=True STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_IRowsetChange ...Would appreciate if someone could help me in this.
Thanx in advance and Regards
-
Every time I had this error it was related to one of the tables not having a primary key.
-
Thanx a lot Jo.
It worked. The Primary key was missing.
-
You're welcome.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply