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