Post reply

updating Informix server in openquery

  • August 19, 2008 at 3:29 am

    #130767

    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!!

  • May 27, 2010 at 5:32 am

    #1173247

    This might help.

    Here's an interesting post

    http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/2be3325b-13ca-4672-b140-ddb0e815a4eb/

    You are in luck. I'm currently still looking into this but have done a significant grind and configured the connection with ODBC. How are you connecting? With the Informix OLEDB? I'm currently waiting for the AIX admin to set something up on the server. He has to run a few scripts to set up the OLEDB properly. I found a page on IBM's site with significant documentation. Please see below. I believe I know what is wrong with my OLEDB connection, it is the set-up. I have a working ODBC now and can help you with that if need be.

    http://www-306.ibm.com/software/data/informix/pubs/library/csdk_29.html

    Regards,

    Matt

    ============================

    You are in luck. I'm currently still looking into this but have done a significant grind and configured the connection with ODBC. How are you connecting? With the Informix OLEDB? I'm currently waiting for the AIX admin to set something up on the server. He has to run a few scripts to set up the OLEDB properly. I found a page on IBM's site with significant documentation. Please see below. I believe I know what is wrong with my OLEDB connection, it is the set-up. I have a working ODBC now and can help you with that if need be.

    http://www-306.ibm.com/software/data/informix/pubs/library/csdk_29.html

    Regards,

    Matt

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply