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