Hi

I created a linked server from MS SQL to Ingres database using OLE DB (MSDASQL). I can query Ingres data (select * from tableName where...) but I cannot update or delete Ingress data. All tables have primary key or unique key.

Here are the errors I get when update or deteling data.

Updating error:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Insufficient base table information for updating or refreshing.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange:etData returned 0x80004005: ].

Inserting error:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: Transaction cannot have multiple recordsets with this cursor type. Change the cursor type, commit the transaction, or close one of the recordsets.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::InsertRow returned 0x80004005: ].

Any help is greatly appreciated.

Tho.