468,507 Members | 1,531 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,507 developers. It's quick & easy.

Unable to hit breakpoint Mixed language SQL C# debugging

Ash
Hi all,
I have a C# web application which calls a number of stored procedures.
I wish to step into the stored procedures while debugging i.e "Mix-mode
debugging":

I have completed the following steps:

Configured DCOM
Connected to database via Server Manager (I can see the SQL server and the
stored procedure)
Enabled SQL Debugging in the project properties

The Debugging components are installed and I think they are working because
I can right click the stored procedure from the server manager and "Step
Into Stored procedure" successfully!

The problem is that I set my breakpoint within the stored procedure run the
project then a

?
appears in the breakpoint when I hover over it I get this message:

"The breakpoint will not currently be hit. Unable to bind SQL breakpoint at
this time. Object containing the breakpoint not loaded."

Ive tried everything I can find can you please help me out !

Thanks in advance

Best Regards
Ashley Rajaratnam
Nov 15 '05 #1
3 1844
Have no idea, but maybe you need to add the sql server to debug processes

Under tools->debug processes, highlight SQL server (sqlmangr.exe?) and
click attach

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Nov 15 '05 #2
Ash
Thanks for the reply Morten

However still no luck tried attaching all of the debuggers to

sqldbreg2.exe
sqlmangr.exe
sqlserver.exe

Any other thoughts?

Thanks Ash

"Morten Wennevik" <Mo************@hotmail.com> wrote in message
news:oprxhvydvzhntkfz@localhost...
Have no idea, but maybe you need to add the sql server to debug processes

Under tools->debug processes, highlight SQL server (sqlmangr.exe?) and
click attach

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Nov 15 '05 #3
"Ash" <N_******@hotmail.com> wrote in news:#EWt$oXmDHA.1884
@TK2MSFTNGP09.phx.gbl:
Thanks for the reply Morten

However still no luck tried attaching all of the debuggers to

sqldbreg2.exe
sqlmangr.exe
sqlserver.exe

Any other thoughts?


You need to have your sql server running under your user account to be able
to attach without problems. if it's running under the system account you
won't get permission to attach to that process.

--
best regards

Peter Koen
-----------------------------------
MCAD, CAI/R, CAI/S, CASE/RS, CAT/RS
http://www.kema.at
Nov 15 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Serdar Kalaycý | last post: by
7 posts views Thread by AC [MVP MCMS] | last post: by
6 posts views Thread by Morgan Packard | last post: by
3 posts views Thread by gieforce | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.