Subject Re: [firebird-support] UDF not found
Author Helen Borrie
At 03:06 PM 10/09/2004 +0000, you wrote:
>I am running Firebird on W2K3. I have a collection of UDFs
>in a single dll. This DLL is installed in c:\program
>files\firebird\UDF\udf.dll. The UDFs are configured in firebird with
>a module name of udf.dll. Just that, no path. This has always worked
>in the past but for some reason it isn't working on this machine. It
>tells me that the module name or entry point cannot be found. Any ideas?

1) Configure the path(s) to your udf libraries in ibconfig by adding an
external_function_directory parameter line for each absolute location where
you want the engine to search for ext function libraries:

external_function_directory "drive:\absolute\path\to\directory"

Stop and restart the server to have it take effect.


2) If it's fairly simple to do so, drop the declarations and redeclare them
without the ".dll" extension on the module name. (Or live dangerously, do
a server shutdown and update the RDB$MODULE_NAME column the RDB$FUNCTIONS
table directly).


3) if you file-copied the database to the new machine, delete it, take a
gbak of the original database and restore it on the new machine.

4) It could just be that the engine doesn't like the name "udf" for an
external func lib.