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