Hello, firebirddev!

Wednesday, October 16, 2013, 11:54:07 PM, you wrote:

ff> I am unable to resolve the issue with UDF.

>> The UDF/DLL is in located in the path described in the firebird.conf:
>> UdfAccess = Restrict D:\Apps\Firebird\Firebird_2_5\UDF;

default parameter
UdfAccess = Restrict UDF
refers to the UDF subfolder, so you do not need to specify full path.

anyway, use ProcessMonitor to monitor fbserver.exe only (it's easier
to use SS here), and to find what it tries to load and where.
Since udf is being loaded only when referred, the simple way is to
- prepare ProcessMonitor to monitor fbserver.exe, and ensure that
nothing else is being monitored
- open your database, prepare to execute query
- clear all output that you see in ProcessMonitor
- execute query that calls your udf - select myudf(...
- return to ProcessMonitor, stop monitoring, and enjoy viewing
log to find what happening during your function load.


--
Dmitry Kuzmenko, www.ib-aid.com