Knowledge Base

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

Article ID: 201961

Article Last Modified on 2/12/2007

Microsoft Plus! Game Pack: Cards & Puzzles
Microsoft Remote Data Services 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.

Keywords: kbdatabase kberrmsg kbprb KB201961