|
[
Permalink
| « Hide
]
Adriano dos Santos Fernandes added a comment - 11/Jul/16 05:31 PM
Help us help you. Just "does not work" do not deserve a tracker entry.
sorry Adriano.
Follow the error below: invalid request BLR at offset 36. function EXTRACTDAY is not defined. module name or entrypoint could not be found. I think you know this UDF, and went through the entire installation and always the same mistake. Incluise this Saturday spoke to Cantu in the FDD 13 that directed me to post the error here, because it also did not help me. This is just an example because my application uses many outas functions of UDF and I would love to move to FB3. I also tested with other UDF (website below) and is the same mistake of not finding the function: http://brtheory.blogspot.com.br/2014/11/database-link-para-firebird-pr-br.html invalid request BLR at offset 59. function OPENCONN is not defined. module name or entrypoint could not be found. Is the MSVC runtime used by this DLL installed? Please check it with dependency walker or similar program.
Visual C++ 2008 vcredist_x64__09_0_30729_06161.exe I have already installed and the same problem. This machine has Fb2.5 installed and it works, just does not work in the installation of FB 3. I tested with another UDF and occurs the same mistake, is it not a BUG of FB3. Note: I've updated the Fb 3 for the current build. Have you installed the correct 'bitness' (32 vs 64) of the UDF which matches the Firebird engine you installed?
I believe so because I used the same files used in the version of Firebird 2.5 64. What currently also is installed on the same machine with the UDF working.
The ICUs 64: icudt44FAU, icuin44FAU, icuio44FAU, icuuc44FAU the Firebird folder (Formerly the folder BIN) and the installation of Runtime C ++ Microsoft version 64 in 2008. I did several tests including other UDFs and no works, this really a great mystery. > The ICUs 64: icudt44FAU, icuin44FAU, icuio44FAU, icuuc44FAU the Firebird folder
Try to put dependencies at the same folder as FreeAdHocUDF (UDF) It also depends on fbclient (or maybe gds23), AFAIK.
Vlad,
I put the DLLs but unfortunately without result. Dmitry, Sorry but I did not. I put the GDS32.DLL in the folder but the error remains. I also tried with another UDF and occurs the same error not find the function. Best Regards Augusto @Augusto: I don't think this is a FirebirdSQL bug.
We made FreeAdHocUDF.dll to work on FB 3.0.4 on Windows just copying the following files to the UDF folder of Firebird. Source: http://freeadhocudf.org/downloads/WIN64_FreeAdhocUDF20101206.zip We only use one function called F_STRIPSTRING. But tested with other functions with no problems found. We copied the files from the source zip to the UDF folder, maintaining the exact names: FreeAdHocUDF.dll <- this one was renamed to match the SQL declaration icudt44FAU.dll icuin44FAU.dll icuio44FAU.dll icuuc44FAU.dll We found that and old version of FreeAdHocUDF.dll also works with icu*30.dll (without the FAU in the name) all in the UDF folder. Be aware that you need to restart the Firebird service and reconnect after copying the files. |