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
> >
>
>