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.