Update fails when using linked server (MS SQL SERVER)

Hi,
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,
UPDATED_DATE = GETDATE()
WHERE colume2 = 2181


Please help.
Regards,
P.C. Vaidyanathan
hardy100Asked:
Who is Participating?
 
NetminderConnect With a Mentor Commented:
Per recommendation, points NOT refunded and question closed.

Netminder
CS Moderator
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is columne2 a primary key of that table?
Is there any primary key on that table?

CHeers
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please note that there is a dedicated MS SQL Server topic area at EE:
http://www.experts-exchange.com/jsp/qList.jsp?ta=mssql

CHeers
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.