Hi Ivan, thanks for your help.

I run "instclient i g" and generate gds32.dll. I moved it to
Firebird\UDF, but, still the same problem.

Any idea what is going on?

[]
Andrei

2006/5/25, Ivan Prenosil <Ivan.Prenosil@...>:

> > I downloaded FreeUDFLib from IBPhoenix, but I'm having problem on
> > trying to use it.
> >
> > I do the following:
> >
> > - Copy FreeUDFLib.dll to %Firebird_Install_Dir%\UDF (there already are
> > fbudf.dll and ib_udf.dll)
> >
> > - Run the following declaration in IBExpert, with a database opened:
> > declare external function f_AgeInMonths
> > date, date
> > returns
> > integer by value
> > entry_point 'AgeInMonths' module_name 'FreeUDFLib';
> >
> > - Commit
> >
> > - And, there is it on UDF List.
> >
> > OK
> >
> > But, when I run this sql in IBExpert I got an error message:
> >
> > select f_ageinmonths(data_aprovado, current_date) from propostas
> >
> > Invalid token.
> > invalid request BLR at offset 60.
> > function F_AGEINMONTHS is not defined.
> > module name or entrypoint could not be found.
>
> The library is linked to old gds32.dll (because of isc_encode_date, isc_decode_date).
> You can let FB installer create that library for you, or you can just
> copy fbclient.dll into UDF/gds32.dll
>
> Ivan
> http://www.volny.cz/iprenosil/interbase/