Subject | Re: [firebird-support] UDF Setup? |
---|---|
Author | Helen Borrie |
Post date | 2005-03-01T02:01:30Z |
At 06:08 PM 28/02/2005 +0000, you wrote:
'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
>I've installed Firebird 1.5.2 and I'm having trouble using theSee my slightly earlier message.
>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.
>It's been suggested that I set useStandardUdf - is that set inNo, it's not a Firebird parameter. It must be a setting in the Java driver.
>firebird.conf like "useStandardUdf = 1" ? I've tried that but it
>doesn't seem to change anything.
>Could I be screwing up the creation of the database itself? All IIf the database doesn't get created here, it's a different problem. Using
>did was this:
>
> > bin\isql -user sysdba -password masterkey
>SQL> create database 'test.gdb' user 'sysdba' password 'masterkey';
>SQL> quit;
'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