Subject Re: FreeUDFLib not working on Vista machine
Author Eric Buescher
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
>
> > I am running Firebird 2.0.1 on a Win2003 server and all is working
> > fine. I have copied my database from the Win2003 server onto a Windows
> > Vista (64bit) machine with Firebird 2.1.1 (for Win64) installed. I
> > have the same FreeUDFLib.dll file copied into the \UDF folder of each
> > Firebird installation.
> >
> > On my Vista machine all the UDFs are listed in the database and show
> > up in the Sql editor of IBExpert. When I try to use one of the UDF's
> > though it errors out with:
> >
> > Invalid request BLR at offset 63.
> > function F_LOWERCASE is not defined
> > module name or entrypoint could not be found
> >
> > Using ISQL I get the following results:
> > SQL> select
> > RDB$FUNCTION_NAME,RDB$FUNCTION_TYPE,RDB$MODULE_NAME,RDB$ENTRYPOINT
> > from RDB$FUNCTIONS;
> >
> > Returns data for all 81 Functions like:
> > F_LOWERCASE 0 FreeUDFLib.dll IB_LowerCase
> >
> > My firebird.conf file contains the default value:
> > #UdfAccess = Restrict UDF
> >
> > Any ideas how I can get my Vista installation to use FreeUDFLib?
> > Thanks for any help,
> > Eric
>
> but this FreeUDFLib is compiled as 32 bit?
> I think the entry points will be completely different.
> You need to compile for 64 bit I presume
> Alan
>
Alan, thanks. I fixed the problem by removing the 64 bit version of
Firefox and loaded the 32 bit version. In the near future I will
probably move to FreeAdhocUDF, which has both 32 and 64 bit versions
and seems to be compatible with FreeUDFLib.

Thanks again,
Eric