Subject Re: Server Access to UDF's in FB 1.52
Author markus_venter
> Superserver reads firebird.conf once, when the server starts up.
When you
> change firebird.conf, stop and restart the server process.
>
> BTW, don't enable ExternalFileAccess in the same directory as your
UDFs
> !!! this is asking for trouble, since it's in the nature of
external file
> usage for data to be read and written by external applications,
human
> beings and monkeys.
>
> Set up a completely separate directory for ExternalFileAccess,
preferably
> right away from the Firebird software directories. Make an
illuminated
> mental note to take great care with permissions for this
directory, to
> exclude the monkeys, at least.
>
> ./hb

I Restarted the server but to no avail. The query I use for testing
my UDF is as follows:

"SELECT STR(12345.543,10,2) FROM
PERSON".

The UDF is the same as the STR function in SQLServer. I disabled
External file access as per your suggestion. Same error message.
Now what?

I am converting a MSSQLServer 2003 DB to FB1.52!!, so I need
transparency as far as the internal functions of SQLServer is
concerned.

Markus Venter