Subject | Strange UDF problem |
---|---|
Author | jvpgr |
Post date | 2008-10-22T23:24:34Z |
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
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