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 ; 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.
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