At 10:03 AM 5/03/2005 +0000, you wrote:

>Hi,
>
>I created a UDF library and copied the DLL to the UDF directory
>under the Firebird installation directory on WINXP Pro.
>
>I configured the Firebird.Conf file to
>--> ExternalFileAccess = Restrict UDF
>--> UdfAccess = restrict UDF
>
>I Registered the UDF in my Database but when I call it I get the
>following message:
>
>"Unsuccessful execution caused by a system error that precludes
>successful execution of subsequent statements.
>Access to UDF library "AVI_UDF.DLL" is denied by server
>administrator."
>
>File access on OS is set to full access.
>
>What am I missing here?

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