Greetings.
From "Server1" I try to perform a distributed UPDATE to a table in "Server2"
UPDATE Server2.dBase2.dbo.Table2 SET Field2 = 'Blabla'
WHERE AnotherBlablabla
and get this error:
Server: Msg 7306, Level 16, State 2, Line 1
Could not open table '"dBase2"."dbo"."Table2"' 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.]
Some remarks:
(1) This is the only one table that gives me this problem.
(2) By now this table is empty (keep in mind this command is part of a stored procedure), but I don't expect that to be the problem.
(3) Both boxes (Server1 and Server2) are MS-SQL 7.0
Please help. Thanks.
J.C.
From "Server1" I try to perform a distributed UPDATE to a table in "Server2"
UPDATE Server2.dBase2.dbo.Table2 SET Field2 = 'Blabla'
WHERE AnotherBlablabla
and get this error:
Server: Msg 7306, Level 16, State 2, Line 1
Could not open table '"dBase2"."dbo"."Table2"' 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.]
Some remarks:
(1) This is the only one table that gives me this problem.
(2) By now this table is empty (keep in mind this command is part of a stored procedure), but I don't expect that to be the problem.
(3) Both boxes (Server1 and Server2) are MS-SQL 7.0
Please help. Thanks.
J.C.