Subject Re: Strange UDF problem
Author jvpgr
--- In firebird-support@yahoogroups.com, "Paul Hope" <paulhope@...> wrote:
>
> FreeUDFLib depends on another dll but I cant quite remember which one. I
> think it is gds32.dll - worth a try.
>
> Regards
> paul
>
> > -----Original Message-----
> > From: firebird-support@yahoogroups.com
> > [mailto:firebird-support@yahoogroups.com] On Behalf Of jvpgr
> > Sent: 23 October 2008 00:25
> > 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
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
>

Correction and apology.

There was gds32.dll, even though I have no clue how has gotten there.
Placing it in the new server solved the problem both with freelib and
rfunc.

Mea culpa...

thanks Paul, and everyone for your time.