Subject | FreeAdhocUDF Error |
---|---|
Author | mourad@bilog.fr |
Post date | 2009-08-25T14:46:03Z |
Hello everybody, I've installed Firebird 1.5 on Mac OS 10.4 PPC. I'm using FreeAdhocUDF as UDF library. For that, I've stopped le firebird service and changed the configuration file Firebird.conf as : UdfAccess = Restrict UDF ; /Library/Frameworks/Firebird.framework/Versions/A/Resources/English.lproj/var/ ;.
After that I've placed the UDF file FreeAdhocUDF in the path indicated below and I start the firebird service.
But when I execute a query using a function, I've the following error :
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
Knowing that an ls -l command of the FreeAdhocUDF file shows :
-rwxrwxrwx 1 idriss firebird 112908 Aug 25 13:10 /Library/Frameworks/Firebird.framework/Versions/A/Resources/English.lproj/var/FreeAdhocUDF.dylib.
In a second time, I've tried to put the UDF file in the default path which is /Library/Frameworks/Firebird.framework/Versions/A/Resources/English.lproj/var/UDF and no modifying the configuration file, but I still have the same error.
Doe's anyone have an idea about this problem and can help me to resolve it.
Many thanks in advance.
Best regards.
After that I've placed the UDF file FreeAdhocUDF in the path indicated below and I start the firebird service.
But when I execute a query using a function, I've the following error :
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
Knowing that an ls -l command of the FreeAdhocUDF file shows :
-rwxrwxrwx 1 idriss firebird 112908 Aug 25 13:10 /Library/Frameworks/Firebird.framework/Versions/A/Resources/English.lproj/var/FreeAdhocUDF.dylib.
In a second time, I've tried to put the UDF file in the default path which is /Library/Frameworks/Firebird.framework/Versions/A/Resources/English.lproj/var/UDF and no modifying the configuration file, but I still have the same error.
Doe's anyone have an idea about this problem and can help me to resolve it.
Many thanks in advance.
Best regards.