Subject Re: [firebird-support] ib_udf windows linux
Author Helen Borrie
At 03:51 PM 21/04/2005 +0200, you wrote:

>Guten Tag firebird-support,
>we use some programs which have their databases running with firebird
>1.5 under windows. but we dont want our data stored on theclients with
>each client running a firebird server and so we installed firebird 1.5
>on our linux-server. first we thought we got it working but there is
>a problem:
>Invalid token.
>invalid request BLR at offset 340.
>function ABS is not defined.
>module name or entrypoint could not be found.
>is shown in some situations. the program seems to call a procedure.
>finally i figured out that only adding a withspace in a comment of this
>procedure and commiting shows the same error. ib_udf is accessible
>(everything set to full acces due to testing).

Assuming that you are talking about the parameter UdfAccess = FULL - do you
understand that this setting requires you to put the full file-path to the
UDF library into the module_name parameter of every UDF declaration?

>also UDF abs is in the
>database as shown in ib_udf.sql.

Which means that your declaration is wrong for UdfAccess = Full

>the database runs prtty
>well on any windows install of firebird.
>where might be the problem?

I can't see any reason at all to use UdfAccess = FULL in your test database
and then have to change all of your UDF declarations in the production
database before you can deploy it. There is no ALTER FUNCTION
statement: you will have to drop all of the functions and then redeclare
them with the correct module_name syntax.

Do you care at all about portability? FULL prevents the database from being
transportable. Think about it...