Subject Re: Strange UDF problem
Author jvpgr
--- In firebird-support@yahoogroups.com, "Michael D. Spence"
<firebird@...> wrote:
>
> > -----Original Message-----
> > From: firebird-support@yahoogroups.com
> > [mailto:firebird-support@yahoogroups.com] On Behalf Of jvpgr
> > Sent: Wednesday, October 22, 2008 7:25 PM
> > To: firebird-support@yahoogroups.com
> > Subject: [firebird-support] Strange UDF problem
> >
> >
> > Hi all,
> >
> > 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.
> >
> > Please help!
> >
> > Yannis
> >
> >
>
> 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.
>
>
>
> Michael D. Spence
> Mockingbird Data Systems, Inc.
>

Hi Michael,

no, there are no dependencies

Yannis