Write it as

select * from MON$ATTACHMENTS;

You were missing the last "S"

Alex

----- Original Message -----
From: "grip_2ls" <lists@...>
To: firebird-support@yahoogroups.com
Date: Thu, 20 Oct 2011 07:54:42 -0000
Subject: [firebird-support] Re: Find out how a user has connected to the
database

> Thomas
>
> We would be connected from Delphi and all our clients are on 2.1. But
before I get this implemented in code I would like to see it in SQL.
>
> I have tried in both IBQuery and isql but whenever I run the following:
>
> select * from MON$ATTACHMENT;
>
> I always get an error that the table is unknown.
>
> Should I be able to run that statement from isql?
>
> Thanks
>
> Neil
>
> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...>
wrote:
> >
> > Hi Neil,
> >
> > > Thanks for the quick response.
> > >
> > > I have a few further questions...
> > >
> > > When I try and select from this table I get a message to say that it
doesn't exist. I am logged in as sysdba - do I need to do anything else?
> > >
> > > My db is 2.1.3.18185 and the GDS32.dll is version 6.3.3.18185
> > >
> > > I assume that the remote process property has to be set as part of
the connection string?
> > >
> > > And finally, I assume that this is available via an api?
> >
> > The following is from the 2.1 release notes.
> >
> > - columns MON$REMOTE_PID and MON$REMOTE_PROCESS contains non-NULL
values
> > only if the client library is version 2.1 or higher
> >
> > - column MON$REMOTE_PROCESS can contain a non-pathname value if an
> > application has specified a custom process name via DPB
> >
> > But I know from Jaybird for instance, that one needs to specify
specific
> > properties, see:
> > http://tracker.firebirdsql.org/browse/JDBC-118
> >
> > But I guess this is related to the thin driver not communicating via
the
> > client library.
> >
> >
> > What access technology do you use and is your mentioned gds32.dll
> > version the one on the client or do we speak about a local installation
> > here anyway?
> >
> > --
> > With regards,
> > Thomas Steinmaurer
> >
> > * Upscene Productions - Database Tools for Developers
> > http://www.upscene.com/
> >
> > * My Blog
> > http://blog.upscene.com/thomas/index.php
> >
> > * Firebird Foundation Committee Member
> > http://www.firebirdsql.org/en/firebird-foundation/
> >
> >
> > > Thanks
> > >
> > > Neil
> > > --- In firebird-support@yahoogroups.com, Thomas Steinmaurer<ts@>
wrote:
> > >>
> > >> Neil,
> > >>
> > >>> I know that it is possible to see who is currently connected to a
database but is it possible to see how they have connected?
> > >>>
> > >>> By which I mean is it possible to see whether they are connected
from, say, IBConsole, IBQuery or an application?
> > >>
> > >> MON$REMOTE_PROCESS in MON$ATTACHMENT, but AFAIK this needs at least
V2.1
> > >> of the client libraries.
> > >>
> > >>
> > >> --
> > >> With regards,
> > >> Thomas Steinmaurer
> > >>
> > >> * Upscene Productions - Database Tools for Developers
> > >> http://www.upscene.com/
> > >>
> > >> * My Blog
> > >> http://blog.upscene.com/thomas/index.php
> > >>
> > >> * Firebird Foundation Committee Member
> > >> http://www.firebirdsql.org/en/firebird-foundation/
> > >>
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > >
> > > Visit http://www.firebirdsql.org and click the Resources item
> > > on the main (top) menu. Try Knowledgebase and FAQ links !
> > >
> > > Also search the knowledgebases at http://www.ibphoenix.com
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>