Microsoft KB Archive/253102

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:16, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


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