Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2002

    Exclamation Unanswered: insert using linked server to informix failed


    I'm currently having a nasty problem... I have a Linked Server (using a ODBC Data Source) configured in a MS-SQL Server 7 to a Informix server. I'm very sure that the ODBC is well configured (I can insert, update and delete when I'm not using the Linked Server).

    But using the Linked server, when I try to insert:

    insert into MIMO.mimo.informix.cemi values (1, '12312312', 1, '2002-01-01 12:12:12', '2002-01-01 12:12:12')

    I got the following message:

    Server: Msg 7399, Level 16, State 1, Line 1
    OLE DB provider 'MSDASQL' reported an error. The provider reported an unexpected catastrophic failure.
    [OLE/DB provider returned message: Query cannot be updated because the FROM clause is not a single simple table name.]

    Using these sintax to select, delete or update, everything works fine...

    select * from MIMO.mimo.informix.cemi
    delete from MIMO.mimo.informix.cemi where nr_esn = 1
    update MIMO.mimo.informix.cemi set nr_esn = 3

    Can anyone help me? Please...

    Thanks anyway....

    PS: I'm using INFORMIX Client-SDK 2.70 ODBC driver to connect to the remote database
    Last edited by ale.rc; 07-05-02 at 19:31.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts