Handling errors raised from a SQL Server stored procedure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I call a SQL Server stored procedure using ADO 2.5 in an Access 2000 app.
This stored proc does many things and I've got much error handling code in
it. It is designed to encounter and handle many errors. However, when the
sproc is run by my app, it stops execution at the first error. When the
sproc is run in SQL Query Analyzer, it reports many errors, but runs to
completion.

What do I need to do to my app/ ADO code to allow this sproc to run to
completion?

Thank you for the help.
.

Relevant Pages

  • Re: Run ADO/OLE DB from a CD-R
    ... > I need to get my VB6 app. ... > installing any files onto the host machine, or making any registry entries of ... > also have had Visual Studio installed, however on all other machines, the ADO ... Do you mean the bound-control 'ADODC' when you say 'ADO control'? ...
    (microsoft.public.data.ado)
  • RE: Problem using COMPUTE with SPROC on ADO connection
    ... This question is better asked in a traditional ADO group or the SQL Server ... When you contact a sproc in Query Analyzer, any items, like your COMPUTE ... placed in a seaparate Recordset, and you will have to get next to retrieve it. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Run ADO/OLE DB from a CD-R
    ... using ADO/OLE Db from a CD. ... I need to get my VB6 app. ... also have had Visual Studio installed, however on all other machines, the ADO ... I've tried to include all possible files on the CD (MDAC, ADO, Jet, etc etc) ...
    (microsoft.public.data.ado)
  • Re: DataGrid, DataBinding, ... help!
    ... I'm not using ADO. ... ADO is not the backend database engine, it is a data access layer that ... interprets between your app and that backend. ...
    (microsoft.public.vb.general.discussion)
  • Re: Re: Conflict management code
    ... If you are using Access as a repository only and your app is ... written in VB6 then ADO is 'the only way to go'. ... Classic ADO is old and broken and abandoned by MS. ...
    (microsoft.public.access.replication)