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

• Remote Data Service for ADO versions 1.0, 1.5

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.

Additional query words:

Keywords : kberrmsg kbADO kbDatabase kbMDAC kbRDS kbVC600
Version : WINDOWS:1.0,1.5
Platform : WINDOWS
Issue type : kbprb