Subject | Re: Server Access to UDF's in FB 1.52 |
---|---|
Author | markus_venter |
Post date | 2005-03-05T13:17:59Z |
> Superserver reads firebird.conf once, when the server starts up.When you
> change firebird.conf, stop and restart the server process.UDFs
>
> BTW, don't enable ExternalFileAccess in the same directory as your
> !!! this is asking for trouble, since it's in the nature ofexternal file
> usage for data to be read and written by external applications,human
> beings and monkeys.preferably
>
> Set up a completely separate directory for ExternalFileAccess,
> right away from the Firebird software directories. Make anilluminated
> mental note to take great care with permissions for thisdirectory, to
> exclude the monkeys, at least.I Restarted the server but to no avail. The query I use for testing
>
> ./hb
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