Subject problems with udf
Author martinknappe
hi

i just wrote my first udf and tried to use it but it won't work.
I wrote and compiled a dll which you can find here:

http://www1.file-upload.net/download_18.06.06/cz9q8b.rar.html

Next, I declared the udf in ibexpert via copied the dll-file into my
firebird-udf-directory and declared the udf in ibexpert via

DECLARE EXTERNAL FUNCTION REPLACE
CSTRING(100), CSTRING(100), CSTRING(100)
RETURNS CSTRING(100) FREE_IT
ENTRY_POINT 'Replace' MODULE_NAME 'MyFirebirdUDFs'

but when trying it out with

select replace('hallo', 'a', 'e') from rdb$database;

I get:

Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Access to UDF library "MyFirebirdUDFs.DLL" is denied by server
administrator.

I also tried to add the following to my firebird.conf file:

UdfAccess = Restrict UDF; C:\Programme\Firebird\Firebird_1_5\UDF;

But it all doesn't help?

What's the trick here?

Many Thanx!

Martin