When inserting or updating records on an AS400 via a linked server in SQL Server 2000 or 2005, the following error is received:
Error Message: Server: Msg 7399, Level 16, State 1, Procedure usp_SendTo_Moore, Line 91 OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: Query cannot be updated because it contains no searchable columns to use as a key.] OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::InsertRow returned 0x80004005: ].
The solution is to install the latest iSeries Client Access driver from IBM.
It should be at the following level: Version 5 Release 2 Modification Level 0 Service Level SIO8894