Unable to hit breakpoint Mixed language SQL C# debugging

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ash
    #1

    Unable to hit breakpoint Mixed language SQL C# debugging

    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


    Tags: None
    • Morten Wennevik
      #2
      Re: Unable to hit breakpoint Mixed language SQL C# debugging

      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/

        Comment

        • Ash
          #3
          Re: Unable to hit breakpoint Mixed language SQL C# debugging

          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" <MortenWennevik @hotmail.com> wrote in message
          news:oprxhvydvz hntkfz@localhos t...
          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/


            Comment

            • Peter Koen
              #4
              Re: Unable to hit breakpoint Mixed language SQL C# debugging

              "Ash" <N_teract@hotma il.com> wrote in news:#EWt$oXmDH A.1884
              @TK2MSFTNGP09.p hx.gbl:
              [color=blue]
              > 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?[/color]

              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

                Comment

                Previous template Next
                Working...