PLEASE HELP - stored proc 
Author Message
 PLEASE HELP - stored proc
Hi,

I am calling a stored proc in my VB project using ADO.  If the stored proc
generates an error, how do I retrieve that error message (description)?

I already tried printing out the error object from the ADO Connection error
collection.
The description field is always empty.  I can only get the err number.
Please help.


Thanks.
sk



Wed, 19 Nov 2003 06:02:33 GMT
 PLEASE HELP - stored proc

I don't remember the syntax but you should add an event of OnExecuteComplete
to your datasource and there you have EventStatus you can query and you can
get the description. You database should rise-error.

It's not a full answer but I hope it will give you a direction.

Cheers,
Amos



Thu, 20 Nov 2003 07:11:02 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. please help stored proc issue

2. !!!! PLEASE HELP ::stored proc call dies with ODBC

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

4. Please Help with Stored Proc

5. Please Help, Nested stored proc is inconsitent

6. ADO Stored Proc...AAAAAAAAAAAARRG please help

7. -----need help with stored proc---PLEASE

8. Query/View/Stored Proc structure - please help!?

9. Stored Proc Date conversion Problem, Please Help

10. calling Stored Proc with InputOutput params - help please!

11. calling Stored Proc with InputOutput params - help please!

12. PLEASE HELP - Dynamic SQL in a stored proc


 
Powered by phpBB® Forum Software