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 > > >
