By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,681 Members | 1,338 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,681 IT Pros & Developers. It's quick & easy.

CATCH Stored Procedure ERROR ON EXECUTEREADER

P: n/a
Hi all,

i have a sp that produce an error when execute by some special
parameters. i write a program in vb.net that execute it, but i come
accross a strange problem:

when i execute the sp with EXECUTENONQUERY the error is raised, but
if i use EXECUTEREADER, nothing happens(no error is shown).

Can anybody help me?
Has anybody come accross something like this problem?

Thanks
man shahi
Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Without seeing the code or understanding what the stored procedure is
supposed to be doing, it's impossible to say. Or what you're hoping to
achieve by executing it two different ways, one to return a result set
and one to not. In general, SQLS errors with a severity between 11 and
16 can be handled by iterating through the errors in your SqlException
handler. See SQL Books Online and the .NET help file for more info.

-- Mary
MCW Technologies
http://www.mcwtech.com

On 6 Oct 2003 03:50:10 -0700, ma****@yahoo.com (shahi) wrote:
Hi all,

i have a sp that produce an error when execute by some special
parameters. i write a program in vb.net that execute it, but i come
accross a strange problem:

when i execute the sp with EXECUTENONQUERY the error is raised, but
if i use EXECUTEREADER, nothing happens(no error is shown).

Can anybody help me?
Has anybody come accross something like this problem?

Thanks
man shahi


Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.