Results 1 to 4 of 4

Thread: Open connection

  1. #1
    Join Date
    Nov 2002
    Posts
    9

    Unanswered: Open connection

    How can I tell if I left a connection open? I'm calling slq thru ASP pages.
    Thanks,
    Sue

  2. #2
    Join Date
    Sep 2002
    Posts
    53

    Re: Open connection

    Originally posted by belewe92614
    How can I tell if I left a connection open? I'm calling slq thru ASP pages.
    Thanks,
    Sue
    Use the profiler and run a trace on connections. There are trace options to track when a connection opens and closes.
    KDK

  3. #3
    Join Date
    Sep 2002
    Location
    Dallas
    Posts
    7
    You can use the sp_who procedure to see what processes are connected in the server: "EXEC sp_who"

  4. #4
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    I you are using ADO to connect through an ASP you can check your status
    • adStateClosed 0 The object is closed
      adStateOpen 1 The object is open
      adStateConnecting 2 The object is connecting
      adStateExecuting 4 The object is executing a command
      adStateFetching 8 The rows of the object are being retrieved

    See more from this link State Property
    MCDBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •