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