Client Side Cursor and CommitTrans

microsoft.public.sqlserver.programming

19 Aug 2005 9:44 PM

Scott Meloney

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

20 Aug 2005 2:58 AM

Louis Davidson

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

Show quote

"Scott Meloney" <scottm1***@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..????
>
>