Subject | Re: [firebird-support] UDFAccess |
---|---|
Author | Helen Borrie |
Post date | 2004-05-11T13:09:17Z |
At 12:56 PM 11/05/2004 +0000, you wrote:
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
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
>I've searched this group for (and found) some help on UDFAccess, butOK. No quotes.
>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.
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