Cannot Control COMMIT or ROLLBACK Commands When You Use ADO with DB2 and Stored Procedures (259195)
The information in this article applies to:
- Microsoft SNA Server 4.0 SP3
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
; Call stored procedures here
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.
CAUSE
The OLE/DB Provider for DB2 is incorrectly performing the commitment of the transaction.
RESOLUTIONTo 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
STATUSMicrosoft 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.
| Modification Type: | Major | Last Reviewed: | 11/25/2003 |
|---|
| Keywords: | kbbug kbfix kbQFE kbSNA400PreSP4fix kbSNA400sp4fix KB259195 |
|---|
|