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


  Saturday, December 15, 2018


bob tech
Contact Bob
VW Buses
Cook Book


Thomas Toe

  bob Links
Welcome to Nate
Give me a woman who truly loves beer, and I will conquer the world. - Kaiser Wilhelm II
Wider View Insert

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

Insert Category

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