Hi!
I have created the linkd Server for Server2. I can able to make a SELECT query on the required table & also able to INSERT data into that table. But unable to DELETE or UPDATE the table.
It is throwing the following error while executing the DELETE statement :
Server: Msg 7306, Level 16, State 2, Line 1
Could not open table '"pubs"."dbo"."test1"' 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.]
Can anybody helps me in this regard. Its very urgent.
Thanks in advance.
Tapks
I have created the linkd Server for Server2. I can able to make a SELECT query on the required table & also able to INSERT data into that table. But unable to DELETE or UPDATE the table.
It is throwing the following error while executing the DELETE statement :
Server: Msg 7306, Level 16, State 2, Line 1
Could not open table '"pubs"."dbo"."test1"' 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.]
Can anybody helps me in this regard. Its very urgent.
Thanks in advance.
Tapks