The Server version is FB1.5. Further, I cannot get the UDF to load
at all when the server is accessed via the TCP/IP protocol. It only
works with the local protocol. All this is installed on one
machine. Here are the details:

Start FB1.5 service (doesn't matter: Service or application)
Start IBOConsole (Or IBConsole Same result)

Execute the DECLARE function copied from IB_UDF.SQL.

Now, If I connected to the server with protocal TCPIP then the UDF
is not found at all. If I use LOCAL then the UDF works until I stop
IBOConsole. When I reopen IBOConsole the declare is still there but
I get the error executing any statment that refer to the UDF.

Help????



--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 12:22 AM 19/02/2004 +0000, you wrote:
> >I can declare the UDFs from IB_UDF and they work fine until I

close

> >the database. After I restart the databse, the UDF definitionis
> >still there but SQL SELECT, etc. cannot find the UDF entry

point. I

> >get a message sayin ISC ERROR CODE 335544343.
> >
> >Invalid request BLR at offset 8. Function SUBSTRLEN is not

define.

> >Module name or entry point not found.
> >
> >I have placed the UDB.DLL in many locations. FB/UDF, FB/My
> >Application Folder, and WINDOWS/SYSTEM32. Nothing helps.
> >
> >How do I get FireBird to automatically reload my UDF

declaarations?

>
> What server version?
>
> /hb