January 16, 2003 at 12:56 pm
I have got a linked server, and I am trying to update a table using this statement :
UPDATE linkedserver.dbname.dbo.tablename
SET col = 'somevalue'
WHERE col2 = 'something'
But I get this error :
Server: Msg 7306, Level 16, State 2, Line 1
Could not open table '"Payments"."dbo"."PaymentsSupport"' 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.]
All the permissions are correct, I also tried using 'sa' login but I am still getting the same thing. Is something wrong with my oledb drivers ?
Any help is appreciated...
Thanks
C.
January 16, 2003 at 3:52 pm
I cannot remember and I do not have a way to test here nor can I find the article off hand. But I believe you have to have MSDTC running for it to work. I will continue to look if that doesn't work but try it or tell me it is running so I know for sure.
January 16, 2003 at 5:04 pm
Your absolutly correct, Antares686, MSDTC must be running to work with Linked server tables.
I would also check for a unique identifier on the table involved, and verify there are no triggers or constraints that could generate possible row lookup failures....
Might want to check your version of MDAC if all that is OK.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply