updating a linked Informix server in 2005 64bit
updating a linked Informix server in 2005 64bit
(OP)
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!!
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!!
Talk To Other Members