Subject Re: [firebird-support] Re: group by week
Author Helen Borrie
At 03:25 AM 20/10/2003 +0000, you wrote:
>Hi Helen
>
>Well the other day I have the f_weekofyear working in my computer
>which has FB 1.5 rc6 on it ... this time I am trying to get it to work
>on my other computer which has IB 6 open source ... I have try
>registering the udf with and without the *.dll ... but the same error
>is coming out
>
>invalid request BLR at offset 60
>function f_weekofyear is not defined
>module name or entrypoint could not be found.
>
>I have the freeudflib.dll place in ../bin, ../udf ... there is a
>difference on registering a udf from FB 1.5 to IB6?

There is a difference of configuration. *IF* IB 6 supports the
external_function_directory paramter, you need to have an entry like

external_function_directory "c:\Progra~1\InterBase\udf" pointing to
wherever you have udf libraries. NOTICE THE DOUBLE-QUOTES.

If you have them in more than one place, you need one complete
external_function_directory entry for each location.

You'll have to restart the server after configuring.

If IB 6 doesn't recognise it, then you are back to the old rigmarole of
trying it with copies in "likely" places - the system directory, the IB
/bin directory, and so on. Or you could try adding the location to the
system path.

heLen