Linked Server (Informix) - Insert Into

From: simon (simon_shek@kader.com.hk)
Date: 06/07/02 

From: "simon" <simon_shek@kader.com.hk>
Date: Fri, 7 Jun 2002 01:25:45 -0700

Hi all,
I created a linked server (informix). I can update and
delete with it but I cannot use the " insert into
statement). It returns errors
e.g
> select * from openquery (informix_srv, "insert into abc
> values ('text_values')" )

It return errors as follows.
---------------------------------
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'insert into abc values
('text_values')'. The OLE DB provider 'MSDASQL' indicates
that the object has no columns.
--------------------------------------
OR

> insert into informix_srv.dbname.informix.abc values
> ('text_vales')

It reports error.
-----------------
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.]

Anyone can tell me why?
Regards,
Simon

Relevant Pages

  • Custom Provider Crystal Asking for wrong Table
    ... I'm writing my own OLE DB provider for use in Crystal Reports and other ... If I connect to my OLE DB Provider in Visual ... Studio it shows the schema correctly. ...
    (microsoft.public.data.oledb)
  • Re: UPDATE Problem with FoxPro Linked Server
    ... OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::SetData ... SELECTs work fine with the spaces/padding. ...
    (microsoft.public.sqlserver.odbc)
  • DTC Fehler
    ... The operation could not be performed because the OLE DB ... OLE DB error trace [OLE/DB Provider 'MSDASQL' ... Weiß jemand, wo der Fehler liegt, und wie ich den Fehler ...
    (microsoft.public.de.sqlserver)
  • Re: ISAM error when trying to create tablelink
    ... ODBC Provider (MSDASQL) ... "You are strongly encouraged to use one of the native OLE DB Providers ... instead of the Microsoft Open Database Connectivity Provider. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Bulk Copy / BCP problem....please advise
    ... OLE DB provider 'MSDASQL' reported an error. ... Driver] System resource exceeded.] ...
    (microsoft.public.sqlserver.programming)