[#CORE-5306] Problem to use FreeAdHocUDF the firebird 3

Firebird Core

Problem to use FreeAdHocUDF the firebird 3

Created: 11/Jul/16 04:58 PM Updated: 13/Jul/16 04:36 PM

Component/s:

UDF

Affects Version/s:

3.0.0

Fix Version/s:

None

Environment:

Windows 10 and Server 2012 - Firebird 3.0 - FreeAdhocUDF 2010-01-06

QA Status:

No test

Description

« Hide

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

All

Comments

Change History

Subversion Commits

Sort Order:

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

[ Permalink | « Hide ]

Augusto T. da Costa added a comment - 11/Jul/16 06:05 PM - edited

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.

[ Permalink | « Hide ]

Adriano dos Santos Fernandes added a comment - 11/Jul/16 06:13 PM

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

[ Permalink | « Hide ]

Augusto T. da Costa added a comment - 11/Jul/16 06:19 PM

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.

[ Permalink | « Hide ]

Sean Leyne added a comment - 11/Jul/16 08:25 PM

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

[ Permalink | « Hide ]

Augusto T. da Costa added a comment - 11/Jul/16 08:45 PM

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.

[ Permalink | « Hide ]

Vlad Khorsun added a comment - 12/Jul/16 08:40 PM

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

[ Permalink | « Hide ]

Dmitry Yemanov added a comment - 13/Jul/16 11:47 AM

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

[ Permalink | « Hide ]

Augusto T. da Costa added a comment - 13/Jul/16 04:36 PM

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