Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002

    Unanswered: Not able to update data using linked server

    I am working on the database DB1 and have created a linked server to a database DB2. I have the login and password to access the remote server. The user has access to insert, update and delete data on the remote server. When i connect to the linked server and try to update an existing row I get the following error. What could be the problem??

    Server: Msg 7306, Level 16, State 2, Line 1
    Could not open table '"PWALLET"."DBO"."PW_TBL_REDEEMPOINTS"' 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.]

    The SQL I'm trying to execute is

    UPDATE DB2.remoteuser.DBO.tablename
    SET column1 = column1 + 200,
    WHERE colume2 = 2181

    Please help.
    P.C. Vaidyanathan

  2. #2
    Join Date
    Feb 2002
    Houston, TX
    Change your SQL. The syntax for referencing a table on a remote server is SERVER.DATABASE.OWNER.TABLE.

    UPDATE DB2.DatabaseName.DBO.tablename
    SET column1 = column1 + 200,
    WHERE colume2 = 2181
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts