I'm trying to update something in postgresql from sql server 2000 through openquery like following.
UPDATE OPENQUERY(odbcname, 'SELECT name FROM person where id=1') SET name='bla'
Here's the error I'm getting.
"OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: the content was changed before updating]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::SetData returned 0x80004005: ].