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