Thank you all,, its working now :)))))




i copied the studf.dll file to the UDF folder from the old server and its perfect now, thanx again

Lester Caine <lester@...> wrote:
Magnus Titho wrote:

> Ahmad $arhan **** wrote:
>> General SQL error
>> invalid request BLR at offset 403
>> function EXTRACTDATE is not defined
>> Module name or entrypoint could not be found.
>>
> You have to register the UDF containing this function.

I don't get quite so tidy a message when I set up a new machine - but I do
know straight away - forgot to copy the UDF's :)

Later versions of Firebird have slightly different UDF libraries so the
'registration' made in 1.0.2 may not be the same for 1.5. I'm switching to
versions that don't have the '.dll' in the UDF name so that I can switch
between Windows and Linux transparently.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird - http://www.firebirdsql.org/index.php








~{ Ahmad F. Sarhan }~



---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

[Non-text portions of this message have been removed]