Hmm you have a dylib and you compiled it...
However the database is complaining about FreeAdhocUDF.so
Are you sure you are referencing the right UDF?
If you put it in the UDF directory it should work either as
FreeAdhocUDF.dylib or FreeAdhocUDF if I remember correctly.
But can you check something for me...
can you do a
file FreeAdhocUDF.dylib
and tell me what the output is.

Regards
Paul

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/

But the error persists always.

If anyone have a solution for this problem or an other way to use udf on mac
os x I will be thankfull.

Paul Beach
Tel (France): +33 (0) 2 47 58 30 43
Mob (France): +33 (0) 6 79 24 32 32