It was because I didnt have ib_util.dll in the exe path.

I suppose it would have been nice if the embedded readme had specifically
pointed this out rather than just hid it in the list ;-)

Regards
Paul

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Paul Hope
> Sent: 07 January 2008 13:10
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support]UDF access and embedded???
>
> > >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
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>