Microsoft KB Archive/259195

= Cannot Control COMMIT or ROLLBACK Commands When You Use ADO with DB2 and Stored Procedures =

Article ID: 259195

Article Last Modified on 11/25/2003

-

APPLIES TO


 * Microsoft SNA Server 4.0 Service Pack 3

-



This article was previously published under Q259195



SYMPTOMS
When you use ADO with the OLE/DB Provider for DB2 and stored procedures, it is not possible to control the COMMIT or ROLLBACK commands in a transaction. For example, the following code does not work to commit or rollback a transaction: Set objConn = New ADODB.Connection objConn.BeginTrans If OK then objConn.CommitTrans ELSE objConn.RollbackTrans End IF Set objConn = Nothing NOTE: The OLE/DB for DB2 Provider support for stored procedures was added in Microsoft SNA Server 4.0 Service Pack 3.
 * Call stored procedures here



CAUSE
The OLE/DB Provider for DB2 is incorrectly performing the commitment of the transaction.



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 4.0 SP3.

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

Keywords: kbbug kbfix kbsna400presp4fix kbqfe kbsna400sp4fix KB259195

-

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

© Microsoft Corporation. All rights reserved.