Subject RE: [firebird-support] Strange UDF problem
Author Michael D. Spence
> -----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.