updating a linked Informix server in 2005 64bit

[robert030975]

I have version 3.00 with the dll registered.

I can

SELECT FROM OPENQUERY (CERP, 'select * from wf_caldate where caldate = 1010101') which will return one row

However if I try to do a simple update

UPDATE OPENQUERY (CERP, 'select * from wf_caldate where caldate = 1010101')
SET day = 'Tue'

I get The requested operation could not be performed because OLE DB provider "Ifxoledbc" for linked server "CERP" does not support the required transaction interface.

On the off chance I then tried to do it via OPENROWSET but


SELECT a.*
FROM OPENROWSET('Ifxoledbc', 'Server=jvert07;Trusted_Connection=yes;',
'SELECT * from wf_caldate') AS a;

The OLE DB provider "Ifxoledbc" for linked server "(null)" reported an error. The provider did not give any information about the error.

can anyone help!!