Subject | Problems with UDF |
---|---|
Author | arnorog |
Post date | 2007-10-22T10:33:35Z |
L.S.
Fresh install of Firebird-2.0.3.12981-1-Win32 Super Server on WinXP
Pro Workstation.
In IB Expert I've connected to .\examples\empbuild\EMPLOYEE.FDB
Browsing Tables and view works fine.
I've run C:\Program Files\Firebird\Firebird_2_0\UDF\ib_udf2.sql
The UDF's are displayed nicely, no error messages
The query SELECT LTRIM(CUSTOMER.CUSTOMER) FROM CUSTOMER
returns
Invalid token.
invalid request BLR at offset 63.
function LTRIM is not defined.
module name or entrypoint could not be found.
In firebird.conf UdfAccess is default (#UdfAccess = Restrict UDF)
ib_udf.dll is located in UDF directory,
No Restrictions concerning permissions, virusscanners disabled,
firewall Off.
What could be the problem?
Thanks in advance,
Arno Rog
p.s. same behaviour for my production-database with other UDF's on
this Firebird-2.0.3
Fresh install of Firebird-2.0.3.12981-1-Win32 Super Server on WinXP
Pro Workstation.
In IB Expert I've connected to .\examples\empbuild\EMPLOYEE.FDB
Browsing Tables and view works fine.
I've run C:\Program Files\Firebird\Firebird_2_0\UDF\ib_udf2.sql
The UDF's are displayed nicely, no error messages
The query SELECT LTRIM(CUSTOMER.CUSTOMER) FROM CUSTOMER
returns
Invalid token.
invalid request BLR at offset 63.
function LTRIM is not defined.
module name or entrypoint could not be found.
In firebird.conf UdfAccess is default (#UdfAccess = Restrict UDF)
ib_udf.dll is located in UDF directory,
No Restrictions concerning permissions, virusscanners disabled,
firewall Off.
What could be the problem?
Thanks in advance,
Arno Rog
p.s. same behaviour for my production-database with other UDF's on
this Firebird-2.0.3