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

Btw, the database parameter buffer (DPB) is called: isc_dpb_process_name

Worth to check out if it is set by your access components. As you have
mentioned IBQuery, I guess you are using IBX, which doesn't officially
support Firebird, thus I would be surprised if IBX sets this parameter.

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/