Subject Re: [ib-support] Problem Finding UDF dll
Author ibrahim Bulut
Hi

I have downloaded FreeUDFLib before 2 months ago.
I need a date decode function.
So that i setup the freeudflib.
But I can't use this function.
And I seen this message.


You must rename of the dll file.
Because Dll name is wrong.
I Channged the dll name and everthing is ok.

DECLARE EXTERNAL FUNCTION acos
DOUBLE PRECISION
RETURNS DOUBLE PRECISION
ENTRY_POINT "fn_acos" MODULE_NAME "udflib";

This is a declare external function statement.
And it is in the Udflib.Sql
Module name=udflib

But Dll name is not udflib.
You must change name of the dll in Program Files\Borland\Interbase\Udf


Bye..


----- Original Message -----
From: <dan@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, November 07, 2001 7:54 PM
Subject: [ib-support] Problem Finding UDF dll


> Hello All,
>
> I just ran a script on my production Server (InterBase 6.0) to
> declare the functions for FreeUDFLib. They all show up as
> registered UDFsin QuickDesk, but when I go to use them, the server
> claims not to be able to find the module name or entrypoint.
>
> Some other salient facts:
>
> My test server (FB 1.0B2) finds the udf functions with no problem
> I did not install IB 6.0 on the production server in the default
> location.
> When I went to look for a "udf" directory under my IB6 install
> directory there wasn't one. So, I made one and put the
> FreeUDFLib.dll file in there.
> I also tried putting the dll in the bin and root directories for the
> server with no luck.
>
> Here is a sample of the DDL used to declare the functions:
>
> DECLARE EXTERNAL FUNCTION F_RTRIM
> CSTRING (254)
> RETURNS CSTRING (254)
> ENTRY_POINT 'rTrim' MODULE_NAME 'FreeUDFLib.dll';
>
> Is it necessary to re-start ibserver.exe after registering the udfs?
>
> Thanks,
>
> Dan
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>