Subject Re: [firebird-support] UDFAccess
Author Helen Borrie
At 12:56 PM 11/05/2004 +0000, you wrote:
>I've searched this group for (and found) some help on UDFAccess, but
>I'm still struggling with it. I can only manage to use UDFs that are
>in the \UDF directory.
>
>My UDFs are in c:\XXXXX, and I specify :
> UdfAccess = Restrict UDF;"C\XXXXX"
>
>Then restart the server. It doesn't find my UDFs.
>
>Not only that but it says "Access to UDF library "ib_udf.DLL" is
>denied by server administrator" when I try to use a udf defined in
>ib_udf.
>
>If I copy my udfs to \UDF, then all works ok.

OK. No quotes.

My UDFs are in c:\XXXXX, and I specify :

UdfAccess = Restrict UDF;"C\XXXXX"

The first bit works: an unqualified path is treated as relative to the
root directory. the correct entry to access UDFs in both rd\UDF and
c:\XXXXX is:

UDFAccess = Restrict UDF;c:\XXXXX

>Also, what is UdfAccess Full ? Surely one must define a path?

You must define a fully qualified path *in the declaration to the
database*. For example, if you set UDFAccess = FULL then your database
declarations for udf libraries located in c:\XXXXX would be like this:

DECLARE EXTERNAL FUNCTION abs
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'c:\XXXXX\ib_udf.dll';

/heLen