Client Side Cursor and CommitTrans

I am trying to trap an error using VB6, ADO 2.8 and SQL Server 2000. Using
a client side cursor, if I pull the ethernet cable just before issuing a
CommitTrans statement, the CommitTrans succeeds anyway. I cannot get the
Errors collection, or WithEvents to report any problem. What now..'I might consider taking this over to the .vb groups to see what they say.
We mostly talk T-SQL specifically around here.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Scott Meloney" <scottm1100@.yahoo.com> wrote in message
news:%230wkWcQpFHA.3936@.TK2MSFTNGP10.phx.gbl...
>I am trying to trap an error using VB6, ADO 2.8 and SQL Server 2000. Using
>a client side cursor, if I pull the ethernet cable just before issuing a
>CommitTrans statement, the CommitTrans succeeds anyway. I cannot get the
>Errors collection, or WithEvents to report any problem. What now..'
>