473,322 Members | 1,401 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Unable to hit breakpoint Mixed mode debugging C# SQL

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 17 '05 #1
2 4044
I have found that the easiest way to run this is to open the stored
procedure and choose execute from the right click menu. Then, fill in the
values from the application by setting watches. Run until you hit the
breakpoint for the call to the sproc and then execute the sproc, filling in
values.

In the future, this will get less painful, as the next version of SQL Server
is reported to be more CLR friendly. The current system, however, leaves a
bit to be desired. Note, however, that it is better than previous
incarnations of Visual Studio.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************
"Ash" <N_******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
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 17 '05 #2
Ash
Thanks for the reply!

Just to clarify are you saying that it isn't possible to step from VS.net C#
through to a stored procedure breakpoint?

I had it up and running with VS 6.0 (sure it was an add-on nevertheless it
worked!) don't understand why that feature wasn't developed into VS.NET...
:(

In fact this MS article suggests the opposite
T-SQL and Managed or Unmanaged Code
You cannot step into T-SQL from managed or native code or into managed or
native code from T-SQL. To get around this limitation, set a breakpoint in
your SQL code. You can also use Run to Cursor to reach a desired point,
without using a breakpoint.

http://msdn.microsoft.com/library/en...asp?frame=true


Did I misunderstand what you were saying?

Thanks - Ash

"Cowboy (Gregory A. Beamer)" <No************@comcast.netNoSpamM> wrote in
message news:uG**************@tk2msftngp13.phx.gbl...
I have found that the easiest way to run this is to open the stored
procedure and choose execute from the right click menu. Then, fill in the
values from the application by setting watches. Run until you hit the
breakpoint for the call to the sproc and then execute the sproc, filling in values.

In the future, this will get less painful, as the next version of SQL Server is reported to be more CLR friendly. The current system, however, leaves a
bit to be desired. Note, however, that it is better than previous
incarnations of Visual Studio.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************
"Ash" <N_******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
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 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Kevin | last post by:
When I run (F5) my web app and put a breakpoint on page load it won't stop at the breakpoint! The code that's in the routine executes, but ..NET won't stop at the breakpoint! It's driving me...
0
by: Ash | last post by:
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...
3
by: Ash | last post by:
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...
5
by: Adam McKee | last post by:
We are using Visual Studio.NET 2003 in our project with .NET framework 1.1. One of our libraries is a mixed-mode dll assembly consisting of one managed C++ library, and several unmanaged C++...
2
by: | last post by:
Hi, I'm using VS .NET 2003 edition and I had built a web project and I had been using it. But I changed a few settings(why did I ever do that...:( ) Now I'm unable to run my Web application...
16
by: Serdar Kalaycý | last post by:
Hi everybody, My problem seems a bit clichè but I could not work around. Well I read lots of MSDN papers and discussions, but my problem is a bit different from them. When I tried to run the...
4
by: Lonewolf | last post by:
hi, I'm still in the process of transiting from MFC/VC6 to vs2005, and a lot of things are very alien to me. So hope you could bear with me if my question sounds stupid. Basically I have native...
0
by: Brian | last post by:
Hi. I need to place wrappers around a set of legacy VC++ 6 dlls and call them via Asp.Net. This works but I can't step into them. Every time I do, they step over, which is a bit of a nightmare. ...
5
by: Oriane | last post by:
Hi, I have a .Net Visual Studio solution with one asp.net Web application, which uses a Asp.Net Web service. Both are compiled in debug mode, and both are using the Studio development web server...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.