hardy100
asked on
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_R EDEEMPOINT S"' 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.tablena me
SET column1 = column1 + 200,
UPDATED_DATE = GETDATE()
WHERE colume2 = 2181
Please help.
Regards,
P.C. Vaidyanathan
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_R
[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.tablena
SET column1 = column1 + 200,
UPDATED_DATE = GETDATE()
WHERE colume2 = 2181
Please help.
Regards,
P.C. Vaidyanathan
please note that there is a dedicated MS SQL Server topic area at EE:
https://www.experts-exchange.com/jsp/qList.jsp?ta=mssql
CHeers
https://www.experts-exchange.com/jsp/qList.jsp?ta=mssql
CHeers
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is there any primary key on that table?
CHeers