INF: Using Disconnected Recordsets Returned from COMTI (329652)

The information in this article applies to:

Microsoft Host Integration Server 2000
Microsoft COM Transaction Integrator for CICS and IMS 1.0
Microsoft SNA Server 4.0
Microsoft SNA Server 4.0 SP1
Microsoft SNA Server 4.0 SP2
Microsoft SNA Server 4.0 SP3
Microsoft SNA Server 4.0 SP4
Microsoft Host Integration Server 2000 SP1

This article was previously published under Q329652

SUMMARY

If the program that calls a COMTI method has not been written to set the the recordset to the first record after receiving the data from the COMTI method, when you change to a different Microsoft Data Access Components (MDAC) level, a COMTI method that returns a disconnected recordset may not succeed.

You may receive the following error message:

Subscript out of range

MORE INFORMATION

The calling program must set the recordset object to the first record before working with the recordset. You can specify this by using the .MoveFirst method on the recordset.

In Visual Basic, the code appears as follows:

. . .
On Error GoTo MyErrorHandler
Call objCOMTI.MyMethod(intSomeInput, rsMyRecordset)
rsMyRecordset.MoveFirst
. . .

Modification Type:	Minor	Last Reviewed:	5/20/2005
Keywords:	kbinfo KB329652 kbAudDeveloper