Board index MS SQL Server

Handling errors in a stored proc called from c++ program using db-library

Handling errors in a stored proc called from c++ program using db-library

Post by Sukanta Ka » Sat, 06 Oct 2001 06:54:26



Hi!,
I am calling a stored proc from my c++ program. I connect
to sql server using db library.

I am running stored procedure(sp_Proc) in asynchronusly
using dbsqlsend, dbdataready and dbsqlok.

My problem is that, my stored proc is failing at random
places. I mean dbsqlsend is returning SUCCEED, dbdataready
is returning true, but dbsqlok is returning FAILED. But I
am not able to get the error message/number from the
stored procedure. I have registered dbmsghandle and
dberrhandle. But neither of these are reporting any error.

I have also tried to bind the first column using dbbind to
get the error message from stored proc, but it hangs at
this point.

I would like to return the error code from stored proc and
receive it in the C++ program.

Can anyone help me. Thanks in advance.

- Sukanta

 
 
 
Top

Handling errors in a stored proc called from c++ program using db-library

Post by Erland Sommarsko » Tue, 09 Oct 2001 07:35:53



> I am calling a stored proc from my c++ program. I connect
> to sql server using db library.

> I am running stored procedure(sp_Proc) in asynchronusly
> using dbsqlsend, dbdataready and dbsqlok.

> My problem is that, my stored proc is failing at random
> places. I mean dbsqlsend is returning SUCCEED, dbdataready
> is returning true, but dbsqlok is returning FAILED. But I
> am not able to get the error message/number from the
> stored procedure. I have registered dbmsghandle and
> dberrhandle. But neither of these are reporting any error.

> I have also tried to bind the first column using dbbind to
> get the error message from stored proc, but it hangs at
> this point.

> I would like to return the error code from stored proc and
> receive it in the C++ program.

I wouldn't say that I have much intelligent to offer. dbsqlok could
be returning FAIL for some other reason than a stored-procedure error,
but I cannot think of what that could be.

If you switch from asynchrouns execution to synchronous with dbsqlexec,
does this change the scene?

--
Erland Sommarskog, Abaris AB

SQL Server MVP

 
 
 
Top

1. Using a stored proc to call another stored proc

I'm using SQL Server 7.0.  I've got a stored proc that returns a resultset.
I would like another stored proc to be able to call it and cycle through
that resultset.  Can I do even do this, or should I rethink my design?

Thanks, Jon

2. how to read data from Excel

3. VB Async Call to Stored Proc error handling

4. Access ODBC driver non ODBC compliant?

5. I need help on: Stored procedure calls from a C++ program (using Rogue Wave DBTools.h++)

6. Backup and restore ?

7. invalid pointer error, using C++ to call stored procuedure with ADO

8. Equiv to VBA's Instr function for SQL?

9. Calling a Stored proc within a stored proc

10. Stored Proc Call in Stored Proc

11. Need Help on Dynamic Stored Proc Call within Stored Proc w/OUTPUT

12. How to call a stored Proc or Ext Stored proc /T-SQL UDF from VBScript

13. Stored Proc Calling Another Stored Proc


All times are UTC
Board index