John,

Thanks for the clarification!
As far as I'm aware that is the case.
Due to a holiday I can't confirm yet, I'll check it right when I'm back (in 14 day)

Arno

--- In firebird-support@yahoogroups.com, "jft" <jft@...> wrote:
>
> Arnorog,
> Just to clarify (as you talk below about declaring your functions
> in every version of Firebird Server) the script loading/declaring them
> has to be run in each DATABASE in each FB server (obviously you could
> skip running it on those databases where you will never want to use those
> functions) because the error message you are getting sounds just like
> the one you would get if they hadn't been loaded/declared.
> Read through Helen's email (below) again.
> John
> > -------Original Message-------
> > From: arnorog <arno.rog@...>
> > Subject: [firebird-support] Re: Problems with UDF
> > Sent: 25 Oct '07 16:46
> >
> > Helen,
> >
> > Thanks for your reply.
> > I'm very well aware I have to declare my functions in every version of
> > Firebird Server. I've installed serveral firebird servers, on Win2k
> > servers and on workstations, this is the first time I try to install
> > it on a WinXP Sp2 workstation.
> >
> > I did a fresh install of Firebird-2.0.3.12981-1-Win32 Super Server on
> > a WinXP SP2 Prof workstation (no previous versions installed)
> > Did a portable backup from our production database (FB 1.5).
> > Placed the appropriate UDF dll's in the UDF folder. Restarted the FB
> > server and did a restore in Firebird-2.0.3. No error messages during
> > the restore. All views with UDF's generate 'module name or entrypoint
> > could not be found' error.
> >
> > Did a de-install and a re-install of FB server.
> >
> > Ran .\UDF\ib_udf2.sql , the UDF's are displayed nicely, no error
> > messages.
> >
> > Nonetheless the query SELECT LTRIM(CUSTOMER.CUSTOMER) FROM CUSTOMER
> > (and all other use of UDF's) still generates 'module name or
> > entrypoint could not be found' error.
> >
> > Any suggestions?
> >
> > (I've read all relevant posts in this forum on the subject, to no avail)
> >
> > Arno Rog
> >
> > --- In [LINK: mailto:firebird-support%40yahoogroups.com]
> > firebird-support@yahoogroups.com, Helen Borrie <helebor@> wrote:
> > >
> > > At 05:34 PM 24/10/2007, you wrote:
> > > >L.S.
> > > >
> > > >Any suggestions on the belowmentioned matter?
> > > >Te latest version 1.5 server on the same WinXP workstation works
> > > >without a problem.
> > > >
> > > >I'd hate to degrade/get stuck to 1.5
> > >
> > > Do you understand that declaring external functions in one database
> > does NOT make them available to other DBs on the same server - you
> > have to declare your functions in all databases.
> > >
> > > Try running this query in isql (not ibexpert):
> > >
> > > select
> > > RDB$FUNCTION_NAME,
> > > RDB$FUNCTION_TYPE,
> > > RDB$MODULE_NAME,
> > > RDB$ENTRYPOINT
> > > from RDB$FUNCTIONS
> > >
> > > That should give you some lead as to what is confounding the engine...
> > >
> > > ./heLen
> > >
> >
> >
>