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

Thanks for the tip Hellen, I did not use the installer though, I just
used the zip and the installsuper.bat as I did in the other cases as well.

I will give the regsvr32 a try.

Yannis