The function SUBSTR is declared in ib_udf.dll library. ( UDF directory
of the Firebird instalation).
Check if this function is registered on the server.

[]s
Euler Jr.

bkshahu escreveu:

> 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.
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> <http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Computer+security&w3=Computer+technical+support&w4=Computer+training&w5=Free+computer+technical+support&c=5&s=138&.sig=77sbeaNS_CB99ND1NpQ02w>
> Computer security
> <http://groups.yahoo.com/gads?t=ms&k=Computer+security&w1=Technical+support&w2=Computer+security&w3=Computer+technical+support&w4=Computer+training&w5=Free+computer+technical+support&c=5&s=138&.sig=h-vpfglcVDyMom6ZGRj-AA>
> Computer technical support
> <http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical+support&w2=Computer+security&w3=Computer+technical+support&w4=Computer+training&w5=Free+computer+technical+support&c=5&s=138&.sig=0PtYe-giICy1KkECNuG2EA>
>
> Computer training
> <http://groups.yahoo.com/gads?t=ms&k=Computer+training&w1=Technical+support&w2=Computer+security&w3=Computer+technical+support&w4=Computer+training&w5=Free+computer+technical+support&c=5&s=138&.sig=psUjUcHSklN7Uvu_cJch-g>
> Free computer technical support
> <http://groups.yahoo.com/gads?t=ms&k=Free+computer+technical+support&w1=Technical+support&w2=Computer+security&w3=Computer+technical+support&w4=Computer+training&w5=Free+computer+technical+support&c=5&s=138&.sig=isTctikpuewr3b607bkoUA>
>
>
>
> ------------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support>" on the web.
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------------------------------------------------
>