debugger doesn't stop at breakpoint while debugging SQLCLR functio
- From: "Amit" <Amit@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 3 Aug 2005 07:16:25 -0700
Hi,
I have created one simple SQL Server 2005 CLR function in Visual Studio 2005
beta 2. It works fine from SQL Server 2005 management studio April CTP.
When I try to debug this SQL CLR function from Visual Studio 2005, I am
getting the output in Output window along with debug information but it is
not stopping at breakpoint. Output window says ‘No symbols loaded’.
Could you please help me why it is not stopping at break point?
I checked configuration property and it is debug for project and solution.
There is no Web.Conifg file, as it is Database project. So I changed the
debug = true in machine.config file at all required places and restarted the
PC. Note that changing machine.config is not required, as if I debug windows
application project in same solution, debugger is stopping at break point.
I selected the function in Server Explorer -> Database connection ->
Assembly -> Function1. Note that for this connection, Application Debugging
and Allow SQL/CLR debugging options are already selected. I right clicked the
function and selected ‘step into function’. Then it is displaying following
message box.
“There is no source code available for the current location, and Ok and Show
Disassembly buttons are displayed.”
If I right click the function in server explorer and click Execute, it is
displaying the result in output window, but if I right click function and
click Open it displays “ No output available for Object” message box.
In Debug mode, I went to Debug Menu -> Widows -> Modules and opened the
Modules window. I located my module in Modules windows.
Then I right clicked and clicked Load Modules. I browsed the bin/debug
folder of my project and selected the .pdb file, then it gave the message
“The symbol file SqlServerProject1.pdb does not match the module.”.
I went to Debug menu and clicked Attach Process and selected Sqlwb.exe
process and then tried to execute function from SQL Server management studio
but no success. In this debug mode, F10 and F11 are not working in visual
studio, when Sqlwb.exe process is attached to debugger. When I hovered the
mouse over the breakpoint in visual studio, it displays “The Breakpoint will
not currently be hit. The specified module has not been loaded” .tooltip.
Kindly let me know if I am missing something.
Thanks,
Amit.
.
- Follow-Ups:
- Prev by Date: Re: how can I create minidumps of second chance exceptions in .NET 1.1 managed code?
- Next by Date: Re: how can I create minidumps of second chance exceptions in .NET 1.1 managed code?
- Previous by thread: Winforms button: Difference between mouse and keyboard
- Next by thread: RE: debugger doesn't stop at breakpoint while debugging SQLCLR functio
- Index(es):
Loading