Write it as select * from MON$ATTACHMENTS;
You were missing the last "S" Alex ----- Original Message ----- From: "grip_2ls" <[email protected]> To: [email protected] 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 [email protected], 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 [email protected], 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 > > > > >
