Sessions: 201 The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob

  Wednesday, April 17, 2024
Wider View Login

Cluster
DOS
IBM - AS400
     Linked Server to AS4...
MOM
Performance Counters
Service Broker
SQL Server
Windows OS




Will be added as a sub-category of, IBM - AS400
Linked Server to AS400 Update / Insert Error

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