Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem to use FreeAdHocUDF the firebird 3 [CORE5306] #5583

Open
firebird-automations opened this issue Jul 11, 2016 · 10 comments
Open

Problem to use FreeAdHocUDF the firebird 3 [CORE5306] #5583

firebird-automations opened this issue Jul 11, 2016 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Augusto T. da Costa (gustotc)

Use the FreeAdHocUDF in Firebird 2.5 for several years and as I move to Firebird 3.0 just does not work, I've tried a number of ways but to no avail.

I consulted the manual and does not relate to incompatibilities in UDFs.

Can you help me ?

Best Regards

Augusto

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Help us help you. Just "does not work" do not deserve a tracker entry.

@firebird-automations
Copy link
Collaborator Author

Commented by: Augusto T. da Costa (gustotc)

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Is the MSVC runtime used by this DLL installed? Please check it with dependency walker or similar program.

@firebird-automations
Copy link
Collaborator Author

Commented by: Augusto T. da Costa (gustotc)

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Have you installed the correct 'bitness' (32 vs 64) of the UDF which matches the Firebird engine you installed?

@firebird-automations
Copy link
Collaborator Author

Commented by: Augusto T. da Costa (gustotc)

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

> The ICUs 64: icudt44FAU, icuin44FAU, icuio44FAU, icuuc44FAU the Firebird folder
Try to put dependencies at the same folder as FreeAdHocUDF (UDF)

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

It also depends on fbclient (or maybe gds23), AFAIK.

@firebird-automations
Copy link
Collaborator Author

Commented by: Augusto T. da Costa (gustotc)

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

@firebird-automations
Copy link
Collaborator Author

Commented by: Valdir Stiebe Junior (ogecrom)

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant