Necessary additional files from version adhoc 20101111 ****************************************************** FreeAdhocUDF uses from version adhoc 20101111 own compiled, current ICU-libs (Version 4.4.2) for using with UTF-8. To avoid conflicts with the (reduced) ICU-libs from FireBird (version 3.0), we have signed our libs with the extention FAU - and dynamic linking on this files. For this reason it is necessary from version adhoc 20101111, equal for InterBase or FireBird, to use this icu-files. If the system doesn't find this dynamic libs, the database-server sendout following error-message --------------------------------------------- Invalid token. invalid request BLR at offset ... function ... is not defined. module name or entrypoint could not be found. --------------------------------------------- on *every* function of FreeAdhocUDF. Due to OS the icu-files has to be copied and linked to specified locations. * for WindowsXP - from InterBase 2009 and FireBird 2.0 o copy the following files in folder .../bin of the database-server + icudt44FAU.dll + icuin44FAU.dll + icuio44FAU.dll + icuuc44FAU.dll o install the Microsoft Visual C++ 2008 Redistributable Package. You can download it from here: + Microsoft Visual C++ 2008 SP1 Redistributable Package (x86) + Microsoft Visual C++ 2008 SP1 Redistributable Package (x64) * for Windows Vista and Windows 7 - from InterBase 2009 and FireBird 2.0 o copy the following files in folder .../bin of the database-server + icudt44FAU.dll + icuin44FAU.dll + icuio44FAU.dll + icuuc44FAU.dll * for Linux - from InterBase2009 and FireBird 2.0 o copy the following files on folder .../lib of the database-server + libicudataFAU.so.44.2 + libicui18nFAU.so.44.2 + libicuioFAU.so.44.2 + libicuucFAU.so.44.2 o check the path of the other from FreeAdhocUDF used libraries, simply run in folder ../UDF + ldd FreeAdhocUDF.so # where is the location of libib_util.so? * i.e..: in /usr/lib o linking to the same folder than the libib_util.so following symbolic links (look at the cript create_icu-symlinks_for_using.sh) example for Firebird in folder /opt/firebird and libib_util.so in folder /usr/lib: + ln -s /opt/firebird/lib/libicudataFAU.so.44.2 /usr/lib/libicudataFAU.so.44 + ln -s /opt/firebird/lib/libicui18nFAU.so.44.2 /usr/lib/libicui18nFAU.so.44 + ln -s /opt/firebird/lib/libicuioFAU.so.44.2 /usr/lib/libicuioFAU.so.44 + ln -s /opt/firebird/lib/libicuucFAU.so.44.2 /usr/lib/libicuucFAU.so.44 The necessary file you find here ftp://ftp.freeadhocudf.org/FreeAdhocUDF/icu/