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


  Tuesday, March 19, 2019


bob tech
Contact Bob
VW Buses
Cook Book



  bob Links
Q263556 - INF How to...
I wish we could all have good luck, all the time! I wish we had wings! I wish rain was beer! - Robert Bolt, A Man for All Seasons
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