Subject | problems with udf |
---|---|
Author | martinknappe |
Post date | 2006-06-17T22:23:23Z |
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
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