Subject Re: [firebird-support] UDF on linux
Author Helen Borrie
At 11:18 PM 18/08/2009, you wrote:

>The FreeUDFLibC UDF is found in /opt/firebird/UDF
>
>The UDF will register without error,

Not "register". You can DECLARE a UDF that doesn't exist, actually. It just won't work.;-)

>module name or entrypoint could not be found
>
>Now, the problem also occurs with the UDF libraries that are supplied with firebird.
>
>DECLARE EXTERNAL FUNCTION ascii_char
> INTEGER
> RETURNS CSTRING(1) FREE_IT
> ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';
>
>Commit;
>
>select ASCII_CHAR(65) from RDB$DATABASE;
>
>module name or entrypoint could not be found
>
>
>Now, looking at my firebird.conf file
>
>RootDirectory= /opt/firebird/
>UdfAccess = Restrict '/opt/firebird/UDF'

Should be Restrict UDF

>But I have also tried UdfAccess = Full
>
>To no avail.

Wouldn't work with your declaration. To use Full you must declare the *full path* to the module.

>Does anyone know what I am doing incorrectly?

Yes. ;-) Trying to wing it, when the documentation is staring you in the face, right there in firebird.conf.

./heLen