PRB: Error 0x80040e56 When Sorting with RDS 1.5 Data Control (201961)


The information in this article applies to:

  • Remote Data Service for ADO
  • Remote Data Service for ADO 1.5
This article was previously published under Q201961

SYMPTOMS

In an application using the Remote Data Service (RDS) 1.5 data control, if the RDS client updates the recordset and then tries to sort the recordset before the updates have been committed to the RDS server, it returns the following:
Error 0x80040e56

CAUSE

The _com_error 0x80040e56 is mapped to DB_E_PENDINGCHANGES, which indicates that the RDS client recordset has been updated and that these updates have not been committed to the RDS server.

RESOLUTION

Use one of the following workarounds to prevent this behavior:
  • Commit all existing changes to the recordset by calling DIDataFactory::SubmitChanges() before sorting the recordset.
  • Upgrade to RDS 2.0. RDS 2.0 has been modified so that updates to the client recordset do not have to be committed to the server before sorting.

STATUS

This behavior is by design.
Modification Type:MinorLast Reviewed:8/19/2005
Keywords:kbDatabase kberrmsg kbprb KB201961
©2004 Microsoft Corporation. All rights reserved.