Hi Thanks all for the information.
The database is ODS 10.1 so I guess that is the problem. Thanks you all for your help. I will upgrade the db. Neil --- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote: > > Hello Neil, > > > 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? > > Yes, but it's MON$ATTACHMENTS and not MON$ATTACHMENT, sorry. This also > requires a database with an ODS 11.1 or higher database. To check the > ODS, e.g. use gstat -h or AFAIR a: > > SHOW DATABASE; > > in isql shows the ODS as well. > > > So, if you are connecting with a 2.1 server to an older (pre ODS 11.1) > database, the monitoring tables aren't available. To upgrade a database > to the server ODS, run a backup with the old Firebird server and a > restore with 2.1. > > HTH. > > > -- > 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: > >> > >> 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 > > > > > > >