At 08:04 PM 18/03/2008, you wrote:

>I've ported my 1.5 firebird from windows to mac os x 10.4 Tiger. But I was
>not able to use the udf. So I've download the source code from
><http://www.udf.adhoc-data.de/index_fra.html>
>http://www.udf.adhoc-data.de/index_fra.html and I've compiled it to get a
>FreeAdhocUDF.dylib but after integrating it in the database I've always the
>message
>
>*** IBPP::SQLException ***
>
>Context: Statement::Prepare( select F_LOWER(sp_nom) from SP_SPECIALITE )
>
>Message: isc_dsql_prepare failed
>
>
>
>SQL Message : -902
>
>Unsuccessful execution caused by a system error that precludes
>
>successful execution of subsequent statements
>
>
>
>Engine Code : 335544831
>
>Engine Message :
>
>Access to UDF library "FreeAdhocUDF.so" is denied by server administrator
>
>I've changed the firebird.conf by adding " UdfAccess = Restrict Access;
>/Library/Frameworks/Firebird.framework/Version/A/Ressources/English.lproj/va
>r/UDF/

UdfAccess = Restrict
/Library/Frameworks/Firebird.framework/Version/A/Ressources/English.lproj/va
r/UDF

And make sure you remove the # comment symbol. Note that config changes won't take effect until next time you connect (Classic) or next time the server is opened for the first time (SS).

If it still doesn't work, it will be worth checking whether the idiosyncratic dynlib suffix on mac libraries means you need to see UdfAccess = Full and include the full library name in the database declaration.

./heLen