Daniel,

The .dll file is at the UDF's folder and I set the firebird.conf to
point to that place too like say in the readme.txt from firebird folder! I'm
trying use the function as SYSDBA user, so I think I have the permissions to
do that...

There is something else I'm missing?

Tanks for the help..

Jean Derrie Rigo
rigo@...

----- Original Message -----
From: "Daniel Albuschat" <d.albuschat@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, March 22, 2005 10:00 AM
Subject: Re: [firebird-support] FreeUDFLib



On Tue, 22 Mar 2005 09:36:18 -0300, Jean Derrie Rigo
<rigo@...> wrote:
>
> Someone can help me with the FreeUDFLib, more exactly with the Blobs
> Functions... I need to extract the data from a Blob field to a varchar
> field
> and I'm trying to install this UDF's, but, it doesn´t work...
>
> I declare the functions with no problem, but when I try to use the
> functions
> they give me the following message:
>
> the sql statement: select f_blobaspchar(fieldBlod) from table1
>
> the error message: Error at line 1 - invalid request BLR at offset 63
> function F_BLOBASPCHAR is not defined
> module name or entrypoint could not be found
>
> Someone else used this function?
> I appreciate any help, tanks!!!

The functions are initialised on first use, so there won't be necessarily an
error message on declaration if the actual dll/shared object is not in
place.
Make sure that the dll/shared object (.dll or .so file, for
win32/linux respectively)
are located in firebird's UDF directory and have sufficient permissions set
for
the firebird's process user.

Bye,
Daniel

--
eat(this); // delicious suicide



Yahoo! Groups Links