Subject Re: Firebird 1.5 and UDF problem
Author tiresoft0165
Thanks Helen!

I have done as you advised and still can not get any UDF's to work,
for example in a trigger I have:

size_interger = strlen(new.product_id);

I receive the error:

-104
Invalid Token.
invalid request BLR at offset 63.
function STRLEN is not defined.
Module name or entrypoint could not be found.

I have the firebird server loaded at c:\program
files\firebird\firebird_1_5\bin but my actual database file is
located in a different directory. Could this be my problem???

Any help would be greatly appreciated, I have been trying to get
these to work for many days now and am stuck as to what the problem
is or could be.

Paul

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> At 09:30 PM 12/05/2004 +0000, you wrote:
> >I am having a problem with Firebird using the rfunc UDFs. I believe
> >the problem is with my Firebird.Conf file. My current system
> >configuration is as follows:
> >
> >Using Windows XP Pro
> >Regisrty shows:
> >HKey_Local_Machine, Software, Firebird Project, Firebird Server,
> >Instances
> > DefaultInstance = c:\program Files\Firebird\Firebird_1_5\
> >
> >Firebird Server is loaded at:
> >c:\program files\firebird\firebird_1_5\bin
> >
> >My questions are:
> >
> >Where should my Firebird.Conf file be located?
>
> In the RootDirectory, c:\program Files\Firebird\Firebird_1_5\
>
>
> >What settings do I need in the Firebird.Conf file so that it can
find
> >my UDS DLLs?
>
> UDFAccess = Restrict UDF
>
> will have the server look in c:\program Files\Firebird\Firebird_1_5
\UDF
>
> The installation setting is UDFAccess = NONE
>
> If you want it to find them somewhere else, e.g. in c:\MyUDF\files
then it
> would be Restrict = c:\MyUDF\files
>
> >Where should my UDF DLLs be located?
>
> In a protected directory on an NTFS partition with access only for
> Administrator (apart from localsystem, of course).
>
>
> >Does anyone have a list of all the default settings for the
> >Firebird.Conf file?
>
> Yes, everyone does. All of the default settings are in
firebird.conf. You
> will find them commented out in the last line of each entry.
>
> /heLen