estoy tratando de utilizar en SQL Server 2000 la siguiente:
UPDATE OPENROWSET('SQLOLEDB','servidor';'sa';,'SELECT * FROM
basedatos.dbo.tabla')
SET Data = 0
WHERE Tag = 'DRC20FV1926FW'
pero me da el siguiente error:
Server: Msg 7320, Level 16, State 2, Line 2
Could not execute query against OLE DB provider 'SQLOLEDB'. The provider
could not support a required row lookup interface. 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.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute
returned 0x80040e21: SELECT * FROM SC1.dbo.tMCS[PROPIDÛPROP_IRowsetLocate
VALUE=True STATUSÛPROPSTATUS_CONFLICTING], [PROPIDÛPROP_BOOKMARKS
VALUE=True STATUSÛPROPSTATUS_CONFLICTING]].
Alguien puede ayudarme porfavor.?
Leer las respuestas