At 05:48 AM 21/07/2005 +0000, you wrote:

> > > I have tried various options -
> > > Changed UDFAccess param in Firebird.conf.
> > > Change to FULL, RESTRICT, commented also.
> > > Nothing worked.
> > >

I would be curious to know whether you altered these settings and didn't
stop and restart the server after each change. Firebird.conf is loaded
when the server starts. Changes made while the server is running have no
effect until after a stop and restart.

>I am using external library.
>The External UDF is registered in firebird DB.
>This External library is copied in UDF directory in Firebird root
>directory.

I hope you mean that the external library is in your $firebird/udf
subdirectory. If so, then the installation default is as follows:

#UdfAccess = Restrict UDF

That is, the server should find the UDF libraries in that $firebird/udf
subdir.

FULL won't work without dropping and redeclaring all of your UDFs with full
paths in the module_name of EACH declaration. Not a good way to do things.

Would you please paste the *exact* declaration of the substr() function.

>I am using IBO in delphi. And I have changed the referece from GDS32
>to FBCleint.

By this, do you mean that you recompiled your application with the IB_GDS32
variable in IB_Constants.pas changed to = 'fbclient.dll' ? (Note the
correct spelling!)

./heLen