At 08:34 PM 23/06/2004 +0000, you wrote:

>What causes the 'Access to UDF library 'ib_udf.dll' is denied by
>server administrator' error? I am getting this error for the second
>time now. The first time, I just rewrote the sql to eliminate the
>need for the udf function, but that will not work now.
>
>My system particulars are:
> FB 1.5 release version of the embedded dll renamed gds32.dll
> Accessing the database via Delphi and IBObjects.
> udfs are in a ./UDF subdirectory of the app as they should be.
> Win32 system (NT 4.0)
>
>The system has been working fine and is still working well from an XP
>machine that is running the FB 1.5 Superserver locally. I've been
>able to find very little on this on the web/newsgroups/yahoogroups.
>I'm guessing that there is something missing in my setup, but I've
>been unable to find what that would be.
>
>Thanks for any help that you can give.

The embedded server process, unlike the full server process, is owned by
the logged-in system user. Does that user have execute permissions to the
directory where the UDF library is?

Where are the \UDF and \bin directories located relative to your app
executable?

Where are firebird.conf and the renamed fbembed.dll located, relative to
your app executable? If firebird.conf is in the right place, what's the
setting for the UDFAccess parameter?

Do you have a full server installation also on the same machine?

/heLen