Subject Re: [firebird-support] Re: IB_UDF won't reload. Why?
Author Helen Borrie
At 01:46 AM 19/02/2004 +0000, you wrote:
>The Server version is FB1.5. Further, I cannot get the UDF to load
>at all when the server is accessed via the TCP/IP protocol. It only
>works with the local protocol. All this is installed on one
>machine. Here are the details:
>
>Start FB1.5 service (doesn't matter: Service or application)
>Start IBOConsole (Or IBConsole Same result)
>
>Execute the DECLARE function copied from IB_UDF.SQL.
>
>Now, If I connected to the server with protocal TCPIP then the UDF
>is not found at all. If I use LOCAL then the UDF works until I stop
>IBOConsole. When I reopen IBOConsole the declare is still there but
>I get the error executing any statment that refer to the UDF.
>
>Help????

1. Read the release notes - in particular, the stuff about the
configuration parameter UdfAccess (and ExternalFileAccess, too, if you are
using any external file definitions)

2. Go into firebird.conf with a text editor and set the UDFAccess
parameter accordingly. If you used the default setup then change the
parameter to
Restrict = UDF (don't forget to delete the #)

3. Stop and restart the server.

/heLen