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

LifeAsBob

  Tuesday, March 19, 2019

 


Home
Blog
bob tech
Calendar
Contact Bob
Pictures
VW Buses
HomeBrew
Cook Book

 

Faith_Cassidy_6.jpg

  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

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