1)I have two linked servers (Sql2005 and Informix)

2) Have to perform a query on table on Informix from Sql2005 and after treating the information on sql need to update few fields on Informix


The select command works fine:

SELECT * FROM OPENQUERY(INFORMIX, 'SELECT * FROM TABLE_A WHERE TABLE_A.FIELD_B = ''1090835'' ')

but when i try to update de informix table via this command:


UPDATE OPENQUERY (INFORMIX, 'SELECT TABLE_A.FIELD_X FROM recibo WHERE TABLE_A.FIELD_B = ''1090835'' ')
SET TABLE_A.FIELD_X = 'P';


I get this error:


Msg 7390, Level 16, State 2, Line 1
The requested operation could not be performed because OLE DB provider "Ifxoledbc" for
linked server "INFORMIX" does not support the required transaction interface.

I have gone through lots of forums but couldnt figure out any solution.

Thanks in antecipation