> Hi All,
>
> I am facing problem while executing SQL which has UDF
> as a column.
> in Firebird 1.5.2 service version(not the embedded one).
>
> ------------------------------------------------------
> Error Is:
> Message: ISC ERROR CODE:335544343
>
> ISC ERROR MESSAGE:
> invalid request BLR at offset 250
> function SUBSTR is not defined
> module name or entrypoint could not be found
>
> STATEMENT:
> TIBOInternalDataset: "dmIBODataModule_2.Query.IBOqrQuery."
> ------------------------------------------------------
>
> I have tried various options -
> Changed UDFAccess param in Firebird.conf.
> Change to FULL, RESTRICT, commented also.
> Nothing worked.
>
> One strange thing I found is -
> If I rename the FBClient.dll to GDS32.dll in
> c:\WinNT\System32 folder. it works.
> Here my requirement is, I dont want to change the file name.
>
> Problem 2 -
> When I keep FBClient.dll in application directory then
> also UDFs doesnt work. same errro.
>
> Can anybody tell me is ther any issue in Firebird DB server
> having differnt client dll file name(other than FBClient.dll) OR
> placing the client library (FBClient.dll) in different folder.
>
> Can anybody please help me out.
>
> Thanks,
> Bhavesh.

you are using IBO. You probably need to take this to the IBO list. Please
confirm there if you have changed the client library refernce in IBO before
compiling.
Alan