Trapping CommitTrans - returns success even when failed!
- From: "Scott Meloney" <scottm1100@xxxxxxxxx>
- Date: Thu, 18 Aug 2005 18:56:51 -0700
Using VB6, SQL Server 2k, ADO 2.8, I am trying to implement an error handler
for ADO CommitTrans. I pause in the middle of transaction, pull the network
wire, then write more records and call CommitTrans. It completes without
error even though the data was not written. I have checked the Err
collection both in the main line and using withevents. They always indicate
success.. Am I missing something?
TIA!
.
- Follow-Ups:
- Re: Trapping CommitTrans - returns success even when failed!
- From: Val Mazur \(MVP\)
- Re: Trapping CommitTrans - returns success even when failed!
- Prev by Date: ADO security warning
- Next by Date: dataset question
- Previous by thread: ADO security warning
- Next by thread: Re: Trapping CommitTrans - returns success even when failed!
- Index(es):