Subject Re: [firebird-support] UDF Setup?
Author Helen Borrie
At 06:08 PM 28/02/2005 +0000, you wrote:


>I've installed Firebird 1.5.2 and I'm having trouble using the
>standard ib_udf.dll.
>
>I executed the commands in ib_udf.sql via bin\isql.exe ... -i, and I
>tried setting "UdfAccess = Restrict UDF" in firebird.conf, but
>whenever I try to acess the UDF 'LOWER', I get:
>
>Access to UDF library "ib_udf.DLL" is denied by server administrator.

See my slightly earlier message.


>It's been suggested that I set useStandardUdf - is that set in
>firebird.conf like "useStandardUdf = 1" ? I've tried that but it
>doesn't seem to change anything.

No, it's not a Firebird parameter. It must be a setting in the Java driver.


>Could I be screwing up the creation of the database itself? All I
>did was this:
>
> > bin\isql -user sysdba -password masterkey
>SQL> create database 'test.gdb' user 'sysdba' password 'masterkey';
>SQL> quit;

If the database doesn't get created here, it's a different problem. Using
'quit' to exit from isql will cause work to be rolled back if you don't
have SET AUTODDL ON. Use Exit unless you want to roll back uncommitted
work when leaving isql.

Your UDF problem has the hallmarks of a homing problem. Did you use the
installer to install Firebird, or did you just unzip the zip file?

./hb