Bogus, thanks for replying..

>Just a wild guess , but does your UDF is dynamically linked to any Kylix
>shared libraries (rather large) ? If so, maybe it's not present in memory
>when UDF is selected throught TCP/IP connection and someway coudn't be
>found by firebird user (assume your server is running as firebird user).

Hmm, what did you mean by 'dynamically linked' ? The udf source code, it
uses SysUtils and Classes, if that's what you mean.
Yes, the firebird service is running, by default, as user 'firebird'.

>Maybe try to locally run isql as firebird user , connect using
>'localhost:your_databasepath_or_alias' select UDF and look if it causes
>trouble.
>
>If You select UDF locally , is it working good even after reconnect all
>connections.

If I run isql locally and select the udf locally, no problems at all.
The problem only happens when I connect remotely from another machine.

Still looking forward for some clues...

Thanks,

-MARTHA-




==================================

Want to maximize Sales, get FAXtreme
Want to minimize Sales Effort, get FAXtreme
Want to learn more.....,
Contact (021) 5696 3765 or
Email to: sales@...

===================================