Hi,

thanks for your answer. The problem is that I have to deploy a DLL developed by me containing only one function but they give me the same error displayed by those implemented in ib_udf.dll.
The function is QUOTEDSTR: a single quote character (') is inserted at the beginning and end of String, and each single quote character in the string is repeated.
Is there an existing function ?

Thanks
Diego Novati

----- Original Message -----
From: Ivan Prenosil
To: firebird-support@yahoogroups.com
Sent: Sunday, May 02, 2004 6:34 PM
Subject: Re: [firebird-support] Firebird embedded & UDF


> I'm trying to use ABS function imported by ib_udf.dll and INVL imported by
> fbudf.dll but in both case I get the following error message:

You do not need neither of those UDFs.
Instead of INVL() use COALESCE function (which is sql standard),
ABS() can be easily replaced by CASE expression.

Ivan


----- Original Message -----
From: "Diego Novati" <diego.novati@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, May 02, 2004 4:25 PM
Subject: [firebird-support] Firebird embedded & UDF


> Hi,
>
> some days ago I posted a message about Embedded Firebird and UDF but nobody answered me.
>
> Is this the right forum about Firebird Embedded ? I need an help ASAP, because I need to deploy an
application and I'd like to use embedded.
>
> Thanks
>
> Diego Novati
>
> ----- Original Message -----
> From: Diego Novati
> To: firebird-support@yahoogroups.com
> Sent: Saturday, April 24, 2004 3:24 PM
> Subject: [firebird-support] Firebird embedded & UDF
>
>
> Hi,
>
> I'm trying to use ABS function imported by ib_udf.dll and INVL imported by
> fbudf.dll but in both case I get the following error message:
>
> "Unsuccesful execution caused by a system error that precludes execution of
> subsequent statements. Access to UDF library "ib_udf.DLL" is denied by
> server administrator. "
>
> I'm using Firebird 1.5.0.4290 Embedded for Windows
>
> I updated firebird.conf file setting the options:
>
> UdfAccess = Full
>
> or
>
> UdfAccess = Restrict UDF
>
> or
>
> RootDirectory = c:\Firebird-1.5.0.4290_embed_win32
> UdfAccess = Restrict ./UDF
>
> but none of them work.
>
> Any suggestion ?
>
>
> Thanks


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]