Subject | Re: Access to ib_udf.dll denied |
---|---|
Author | Tim Piscitelli |
Post date | 2004-06-24T12:54:53Z |
Thanks for the reply. Here is the setup as it is now:
The directory structure is .\app\bin\udf with the udf dlls in the
given subdirectory of the bin location. The app, embedded dll
(renamed gds32.dll), database and firebird.conf are in the bin
directory. The conf file is set to UDFAccess = Full, as is the
DatabaseAccess parameter.
There is currently no full server installation on that machine, but
there was in the past. Should be no trace of it now though.
Directory permissions are set to Everyone=FullAccess, so that should
not be the problem. I'll dig into the issue of permissions more
though, as that sounds like a possible cause.
Thanks,
Tim
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
The directory structure is .\app\bin\udf with the udf dlls in the
given subdirectory of the bin location. The app, embedded dll
(renamed gds32.dll), database and firebird.conf are in the bin
directory. The conf file is set to UDFAccess = Full, as is the
DatabaseAccess parameter.
There is currently no full server installation on that machine, but
there was in the past. Should be no trace of it now though.
Directory permissions are set to Everyone=FullAccess, so that should
not be the problem. I'll dig into the issue of permissions more
though, as that sounds like a possible cause.
Thanks,
Tim
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> At 08:34 PM 23/06/2004 +0000, you wrote:owned by
> >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
> the logged-in system user. Does that user have execute permissionsto the
> directory where the UDF library is?relative to
>
> Where are the \UDF and \bin directories located relative to your app
> executable?
>
> Where are firebird.conf and the renamed fbembed.dll located,
> 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