Dear Friends,

My client has done a FB installation and I am trying to get my application
to work on his box. I find fbserver.exe version 1.5.2.4731 installed in
C:\Fire_Bird\bin. Using IB_SQL installed on his machine I can open my
database, but when I try to execute a query using the Coalesce() function,
I get an error message that the udf does not exist. I find fbudf.dll in
C:\Fire_Bird\UDF.

Test Query =
select
a.question_number,
coalesce(b.text, a.text),
a.text,
b.text
from questions a
left join alt_question_text b
on b.question_number = a.question_number
and b.client_number = 4
where a.question_number <= 20

result=
ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -804
Function unknown
COALESCE

When I installed firebird on my development machine, the binaries went into
C:\Program Files\Firebird\Firebird_1_5\Bin, and fbudf.dll in C:\Program
Files\Firebird\Firebird_1_5\UDF. Queries using Coalesce() work as expected.

I guess that on the client's installation, the server cannot load
fbudf.dll. How can I fix this problem?
1. Put something in firebird.conf
2. Re-do the installation with conventional paths
3. other...


Thanks,

Walter

/*
C. Walter Ogston
ogstoncw@...
*/