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:
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...
PS: I'm using INFORMIX Client-SDK 2.70 ODBC driver to connect to the remote database