> Is it possible to get a user name, IP address etc using IBO when an error
> occurs(eg deadlock).

No, this is something that I hope is added very soon.

One thing that might be possible is to use a trigger and external tables to
examine what records are locked and by whom. If a deadlock occurs you could
scan through the external table for the most recent occurrence of the locked
record and who has it locked.

External tables are outside of transaction control so through them you can
have dirty reads. The only confusing part is that a rollback doesn't affect
records but you are not going to get a deadlock if the other user rolls back
so its no big deal in this scenario.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com