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