Re: Indexing of Connections

Bob,

Bad me! I should have specified!!! I am using Access

AK

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:%23$bVty9CHHA.652@xxxxxxxxxxxxxxxxxxxxxxx
AK wrote:
I am trying to keep track of my open and closed connections. For
example, if a FileCopy is trying to execute, sometimes I get
connection open error and I need to know what connection (s) it is
(like on some other form that I had previously called) that is
causing the problem.
This cause me to ask if connections made to a DB are indexed or
numbered, and can I get to that "property"? If so, how is that done?

It depends on the database. For example, with SQL Server, one can use the
sp_who2 systmen stored procedure to vies connection info.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"



.

Relevant Pages

  • Re: Operation is not allowed...
    ... > If the connection is open, can I execute two statements against it ... > Dim cmsRS, cmsSQL ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: Indexing of Connections
    ... connection open error and I need to know what connection it is ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Passing recordset between pages
    ... Before closing the connection: ... Recordset Results and display the results ... Execute does not make the local variables in page 1 available in page 2, ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: insert Q
    ... Create a connection object ... > select top 1 from MSysobjects ... > dim lrecs, cn ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: insert Q
    ... > RS_Insert.ActiveConnection = strCon ... You don't want to turn off connection pooling, ... dim lrecs, cn ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)