--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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

Many thanks for your prompt answer. At last I understand it !!

colin