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

LifeAsBob

  Saturday, December 15, 2018

 


Home
Blog
bob tech
Calendar
Contact Bob
Pictures
VW Buses
HomeBrew
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

Cluster
DOS
IBM - AS400
     Linked Server to AS4...
MOM
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