views:

234

answers:

0

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: ].