Microsoft KB Archive/253102

= COMTI Returns ADO Recordset That Cannot Be Sorted =

Article ID: 253102

Article Last Modified on 1/16/2004

-

APPLIES TO


 * Microsoft SNA Server 4.0 Service Pack 2
 * Microsoft SNA Server 4.0 Service Pack 3
 * Microsoft COM Transaction Integrator for CICS and IMS 4.0 SP2
 * Microsoft COM Transaction Integrator for CICS and IMS 4.0 SP3

-



This article was previously published under Q253102



SYMPTOMS
A recordset that contains strings cannot be sorted when it is returned by COM Transaction Integrator (COMTI). When you attempt to sort the recordset, the client application displays the following error message:

Execution error '-2147217824 (80040e60)': Unable to open requested order



CAUSE
In SNA Server versions 4.0 Service Pack 2 (SP2) and later, the string's data type is coerced to adLongVarWChar, which makes the recordset unsortable. Previous to SP2, the data type is coerced to adVarWChar.



RESOLUTION
To resolve this problem, obtain the latest service pack for SNA Server 4.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

215838 How to Obtain the Latest SNA Server Version 4.0 Service Pack



STATUS
Microsoft has confirmed that this is a problem in Microsoft SNA Server, versions 4.0 SP2, 4.0 SP3, Microsoft COM Transaction Integrator for CICS and IMS, versions 4.0 SP2, 4.0 SP3.

This problem was first corrected in SNA Server 4.0 Service Pack 4.

Keywords: kbbug kbfix kbsna400presp4fix kbqfe kbsna400sp4fix KB253102

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.