Trapping CommitTrans - returns success even when failed!

microsoft.public.sqlserver.programming

19 Aug 2005 1:57 AM

Scott Meloney

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!

19 Aug 2005 7:29 AM

GregO

Hi Scott,
Perhapes the SQL code is working but not raising any errors? ADO is pretty
mature now and I haven't heard of this error before. If ADO isn't raising
an error then there may be nothing wrong with the SQL even though no data is
written.

Try running the profiler over the DB to see exactly what your program is
sending and then try those commands in QA

--
kind regards
Greg O
Need to document your databases. Use the firs and still the best AGS SQL
Scribe
http://www.ag-software.com

Show quote

"Scott Meloney" <scottm1***@yahoo.com> wrote in message
news:uXn47EGpFHA.3760@TK2MSFTNGP10.phx.gbl...
> 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!
>
>