all groups > visual studio .net debugging > july 2004 >
You're in the

visual studio .net debugging

group:

Unable to break in Stored Procedure



Unable to break in Stored Procedure Juan Dent
7/14/2004 6:00:01 PM
visual studio .net debugging: I cannot debug a SQL Stored Procedure from within a C# program, even though I have SQL Debugging enabled for that project and everything else has been checked with the instructions in MSDN DVD.

The funny and confusing thing is thay I can debug a stored procedure in Query Analyzer with no problems at all. I can also Step Into Procedure from within VS.NET 2003. It is only when I execute an OleDbCommand whose type is StoredProcedure that my breakpoints in the Stored procedure are missed. I tried ExecuteNonQuery and ExecuteReader to no avail.

Also, I used to be able to do this, prior to my current installation - I had to reinstall my laptop.

When I point my cursor at the breakpoint, a yellow message saying "The breakpoint will not currently be hit. Unable to bind SQL breakpoint at this time. Object containing the breakpoint not loaded."

Any ideas?

--
Thanks in advance,

RE: Unable to break in Stored Procedure Jurgen_O
8/13/2004 1:43:02 PM
I have the same problem.

[quoted text, click to view]
AddThis Social Bookmark Button