Subject Re: Cannot find UDF function
Author Adam
--- In firebird-support@yahoogroups.com, Lorenzo Lamas
<lorenzo_lamas123@...> wrote:
>
> And if I try to execute this statement from the sql editor I get the
following error
>
> Unsuccessful execution caused by a system error that precludes
> successful execution of subsequent statements.
> Access to UDF library "ib_udf.DLL" is denied by server administrator.

Lorenzo,

This looks like an OS level file permission issue. The user that the
Firebird service installs under (LOCALSYSTEM by default) needs to have
permissions to the dll. Also make sure your Firebird.conf file allows
access to this folder (start with FULL until you have it working, then
you can try restrict). Remember that these changes will not take
effect until you restart the service. Also the database will need to
have the declare external function thing executed. Make sure the path
in the declaration matches the path the dll is in.

Adam