Re: Indexing of Connections

In that case, it's not perfect but the only thing you can do is inspect the
..ldb file. It's been a few years since I did Access development but ISTR
there was something called ldbviewer or something like that. Google should
help you out:
http://www.google.com/search?ie=UTF-8&oe=UTF-8&sourceid=gd&q=ldbviewer+ldb+viewer

AK wrote:
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"

--
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: Updating column property on table gives error
    ... in code instead of when the append happens. ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Writing a GUID to a SQL table
    ... I strongly suspect that it is SQL Server, ... >> Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: YYYYMMDD
    ... > breakpoint but it dosen't stop it at the breakpoint,should I add ... >> a quicker response by posting to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Error in asp page
    ... This is because you need to turn Simple File Sharing off. ... >> quicker response by posting to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: Question about query sql server database
    ... instantiate and open an ADO connection, ... the newsgroup where everybody can read them, ... The email account listed in my From ... header is my spam trap, so I don't check it very often. ...
    (microsoft.public.scripting.vbscript)