Interbase 7 has some nice additional temporary system tables. One
feature I see as very usefull is the ability to obtain a connected
user's IP address. This is found in the TMP$ATTACHMENTS table in
the TMP$USER_IP_ADDR column (only in >= Interbase 7) Is there some
way to query for this info in Firebird (either a SELECT query on a
system table or through the api)?

The following link discusses the temporary tables of IB 7
What's New in InterBase 7 by Bill Todd:
http://users.volja.net/interbase/

I am building replication into my database network. And obtaining
the full database path, dynamically, of a remote host is required.
(due to DHCP and hosts changing locations (ex. labtops))

love Firebird,
Joshua