Subject RE: [firebird-support]UDF access and embedded???
Author Paul Hope
> >Hello Helen
> >
> >> >
> >> >I know this has been asked lots of times before - I've
> checked the
> >> >answers and still cant get it to work :-(
> >> >
> >> >WIN2K Pro client being used to setup embedded demo
> >> >
> >> >c:\ppdemo\app.exe
> >> >c:\ppdemo\gds32.dll (renamed embedded version 1.5.3.4870)
> >> >c:\ppdemo\firebird.conf c:\ppdemo\udf\ib_udf.dll
> >> >
> >> >firebird.conf has
> >> >UdfAccess = Restrict UDF
> >> >
> >> >when I run 'select substr('abcdefg',2,2) from rdb$database'
> >> in ibexpert
> >> >I get 'Access to UDF library "ib_udf.DLL" is denied by server
> >> >administrator.'
> >> >
> >> >No file access restrictions as far as I can tell.
> >> >
> >> >Any ideas please?
> >>
> >> Is the IBExpert executable in c:\ppdemo ?
> >>
> >> ./heLen
> >
> >No. Dont think I want to put it there - is there an alternative or
> >should I ask HK?
>
> Well, any client app that's going to use Fb Embedded needs to
> be in the application root directory..so, if you want to
> deploy IBExpert as part of your embedded setup, either put it
> there, or set up a complete stand-alone setup similar to
> above, except with the IBExpert executable as the application.
>
> ./heLen

I dont want to deploy it, Im just trying to use it to modify the metadata,
it wont let me modify any procedures that reference a UDF.

I'll send a question to HK ;-)

Regards
Paul