One time when I migrated a db to a different server, I restored the
db before I had put all the udfs on the server. I did not see any
errors when the database was restored, but it did cause problems in
stored procedures that used those functions. I believe, sorry it has
been a long time, all I did was drop and recreated the affected
stored procedures.

Hope this helps.
trac

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:

>
>
> >
> >> I am trying to transfer a working fb database to a newly

installed Win

> >> 2003 Server R2.
> >>
> >> The FB superserver is installed in it's default position ie

c:\program

> >> files\firebird\firbird_1_5 and all the UDFs are at c:\program
> >> files\firebird\firbird_1_5\udf.
> >>
> >> UDFAccess in firebird.conf is Restricted UDF.
> >>
> >> The permissions to the UDF folder and to the files in it are

correct.

> >>
> >> the udf declarations are as follows:
> >>
> >> DECLARE EXTERNAL FUNCTION F_MAXDATE
> >> DATE,
> >> DATE
> >> RETURNS DATE
> >> ENTRY_POINT 'MaxDate' MODULE_NAME 'FreeUDFLib';
> >>
> >> there are three UDF libraries used FreeUDFLib, rbudf and ib_udf.
> >>
> >> when I access the UDFs in ib_udf either by a select from

rdb$database

> >> or from some procedure / view everything works fine. When I am

doing

> >> the same for UDFs from the other libs I get the "module name or
> >> entrypoint could not be found" etc error.
> >>
> >> The database is working happily in other 3 similar servers
> >> w/o problems.
> >>
> >> Any advice would be extremely appreciated.
> >
> At 11:14 AM 23/10/2008, Michael Spence wrote:
>
>
> >Do the other libs have .dlls that they depend on, like VC or Delphi
> >runtime stuff? Perhaps these .dlls are on the three servers that
> >work but not on the one that fails.
>
> Another thought is that on Server2003 you need to register dlls,

which the Firebird installer does for the shipped libs. The command
on a 32-bit Windows is regsvr32 - I guess you'll need to Google for
regsvr64 or similar - I can't say whether the "32" part refers to the
OS or the library...

>
> ./heLen
>