Subject Re: Accessing UDF's in Firebird 1.5.4 / 2.0 on Windows Vista
Author martinagren
Hi,
From the function name it looks you are using the old FreeUDFLib
functions. If so, then I had the same problem - they can't be
accessed from 1.5.4 and later it seems. Try accessing an udf in one
of the libraries shipped with Firebird and you'll succeed.

As to the reason, I havn't got any respons from this list. But
something has surely changed between 1.5.3 and 1.5.4.

/M



--- In firebird-support@yahoogroups.com, matteo <matteo@...> wrote:
>
> bmatinha ha scritto:
> >
> > --- In firebird-support@yahoogroups.com
> > <mailto:firebird-support%40yahoogroups.com>, "Daniel Albuschat"
> > <d.albuschat@> wrote:
> > >
> > > 2007/1/24, bmatinha <bmatinha@>:
> > > > Hi,
> > > > anyone sucessfully using udf's in windows vista?
> > > > Thanks in advance.
> > >
> > > Did any problems pop up when you tried to do so?
> > > If so, what kind of problems?
> > >
> > > Regards,
> > > Daniel
> > >
> >
> > With Isql i can connect and when i do a select from a table using
a
> > function of an udf.
> >
> > Example:
> >
> > SELECT F_YEAR(DATA_INSTALACAO) FROM TABLE;
> >
> > ERROR:
> > Statement failed, SQLCODE = -104
> > invalid request BLR at offset 60
> > -function F_YEAR is not defined
> > -module name or entrypoint could not be found
> >
> > This happens with both 1.5.4 or 2.0
> >
> >
> >
> > Messages in this topic
> > <http://groups.yahoo.com/group/firebird-
support/message/83391;_ylc=X3oDMTM2bjlta3Y2BF9TAzk3MzU5NzE0BGdycElkAzI
0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzgzNDE0BHNlYwNmdHIEc2xrA3Z0c
GMEc3RpbWUDMTE2OTY1NDA5MAR0cGNJZAM4MzM5MQ-->
> > (4) Reply (via web post)
> > <http://groups.yahoo.com/group/firebird-
support/post;_ylc=X3oDMTJxZmRqcnF0BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYE
Z3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzgzNDE0BHNlYwNmdHIEc2xrA3JwbHkEc3RpbW
UDMTE2OTY1NDA5MA--?act=reply&messageNum=83414>
> > | Start a new topic
> > <http://groups.yahoo.com/group/firebird-
support/post;_ylc=X3oDMTJlOWZhM3FsBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYE
Z3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTE2OTY1NDA5MA
-->
> >
> > Messages
> > <http://groups.yahoo.com/group/firebird-
support/messages;_ylc=X3oDMTJlNmI3dnM4BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0
MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA21zZ3MEc3RpbWUDMTE2OTY1ND
A4OQ-->
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups
> >
<http://groups.yahoo.com/;_ylc=X3oDMTJkNG9xZXQ1BF9TAzk3MzU5NzE0BGdycEl
kAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxM
TY5NjU0MDkw>
> >
> > Change settings via the Web
> > <http://groups.yahoo.com/group/firebird-
support/join;_ylc=X3oDMTJmbmgwNzY0BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYE
Z3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzExNjk2NTQwOT
A->
> > (Yahoo! ID required)
> > Change settings via email: Switch delivery to Daily Digest
> > <mailto:firebird-support-digest@yahoogroups.com?subject=Email%
20Delivery:%20Digest>
> > | Switch format to Traditional
> > <mailto:firebird-support-traditional@yahoogroups.com?
subject=Change%20Delivery%20Format:%20Traditional>
> >
> > Visit Your Group
> > <http://groups.yahoo.com/group/firebird-
support;_ylc=X3oDMTJkbm11NWpoBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc
3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMTY5NjU0MDkw>
> > | Yahoo! Groups Terms of Use <http://docs.yahoo.com/info/terms/>
|
> > Unsubscribe
> > <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=>
> > Recent Activity
> >
> > *
> > 25
> > New Members
> > <http://groups.yahoo.com/group/firebird-
support/members;_ylc=X3oDMTJmazBqOHBzBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0M
DYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzExNjk2NTQ
wODk->
> >
> > Visit Your Group
> > <http://groups.yahoo.com/group/firebird-
support;_ylc=X3oDMTJlMTdiOXJvBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc
3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTE2OTY1NDA5MA-->
> >
> > SPONSORED LINKS
> >
> > * Computer telephony
> >
<http://groups.yahoo.com/gads;_ylc=X3oDMTJjZHMwZnI0BF9TAzk3MzU5NzE0BF9
wAzEEZ3JwSWQDMjQ0MjQwNgRncnBzcElkAzE3MDUxMTUzODYEc2VjA3NsbW9kBHN0aW1lA
zExNjk2NTQwOTE-?
t=ms&k=Computer+telephony&w1=Computer+telephony&w2=Portable+computer&w
3=Technical+support+software&w4=Technical+support&w5=Computer+telephon
y+integration&c=5&s=138&g=2&.sig=K2fkziACQASatLiNyCW3bw>
> > * Portable computer
> >
<http://groups.yahoo.com/gads;_ylc=X3oDMTJjc2xlOW9oBF9TAzk3MzU5NzE0BF9
wAzIEZ3JwSWQDMjQ0MjQwNgRncnBzcElkAzE3MDUxMTUzODYEc2VjA3NsbW9kBHN0aW1lA
zExNjk2NTQwOTE-?
t=ms&k=Portable+computer&w1=Computer+telephony&w2=Portable+computer&w3
=Technical+support+software&w4=Technical+support&w5=Computer+telephony
+integration&c=5&s=138&g=2&.sig=t_irHVBt3GCJpXAARgKOmA>
> > * Technical support software
> >
<http://groups.yahoo.com/gads;_ylc=X3oDMTJjbzkzbm8yBF9TAzk3MzU5NzE0BF9
wAzMEZ3JwSWQDMjQ0MjQwNgRncnBzcElkAzE3MDUxMTUzODYEc2VjA3NsbW9kBHN0aW1lA
zExNjk2NTQwOTE-?
t=ms&k=Technical+support+software&w1=Computer+telephony&w2=Portable+co
mputer&w3=Technical+support+software&w4=Technical+support&w5=Computer+
telephony+integration&c=5&s=138&g=2&.sig=rgJfmO4shVdh_5aLYTXxTQ>
> > * Technical support
> >
<http://groups.yahoo.com/gads;_ylc=X3oDMTJja2Z0Yjk5BF9TAzk3MzU5NzE0BF9
wAzQEZ3JwSWQDMjQ0MjQwNgRncnBzcElkAzE3MDUxMTUzODYEc2VjA3NsbW9kBHN0aW1lA
zExNjk2NTQwOTE-?
t=ms&k=Technical+support&w1=Computer+telephony&w2=Portable+computer&w3
=Technical+support+software&w4=Technical+support&w5=Computer+telephony
+integration&c=5&s=138&g=2&.sig=D9ZYqTRXSI38PrPcv9bDSA>
> > * Computer telephony integration
> >
<http://groups.yahoo.com/gads;_ylc=X3oDMTJjOWNjdmF1BF9TAzk3MzU5NzE0BF9
wAzUEZ3JwSWQDMjQ0MjQwNgRncnBzcElkAzE3MDUxMTUzODYEc2VjA3NsbW9kBHN0aW1lA
zExNjk2NTQwOTE-?
t=ms&k=Computer+telephony+integration&w1=Computer+telephony&w2=Portabl
e+computer&w3=Technical+support+software&w4=Technical+support&w5=Compu
ter+telephony+integration&c=5&s=138&g=2&.sig=qIsM5N4VmTSGcElPEs9V1w>
> >
> > New business?
> >
> > Get new customers.
> >
<http://us.ard.yahoo.com/SIG=12i11cnq1/M=493064.9803227.10510220.86745
78/D=groups/S=1705115386:NC/Y=YAHOO/EXP=1169661291/A=3848640/R=0/SIG=1
31an6mds/*http://searchmarketing.yahoo.com/arp/srchv2.php?
o=US2002&cmp=Yahoo&ctv=Groups1&s=Y&s2=&s3=&b=50>
> >
> > List your web site
> >
> > in Yahoo! Search.
> >
> > Sell Online
> >
> > Yahoo!
> >
<http://us.ard.yahoo.com/SIG=12i7vlnum/M=493064.9803229.10510223.86745
78/D=groups/S=1705115386:NC/Y=YAHOO/EXP=1169661291/A=4025302/R=0/SIG=1
2bsapn24/*http://us.rd.yahoo.com/evt=44092/*http://smallbusiness.yahoo
.com/merchant>
> > e-commerce
> >
> > comes with 24 hour
> >
> > phone support.
> >
> > Yahoo! Groups
> >
> > Start a group
> >
<http://groups.yahoo.com/start;_ylc=X3oDMTJvcjY2aTA1BF9TAzk3MzU5NzE0BF
9wAzMEZ3JwSWQDMjQ0MjQwNgRncnBzcElkAzE3MDUxMTUzODYEc2VjA25jbW9kBHNsawNn
cm91cHMyBHN0aW1lAzExNjk2NTQwODk->
> >
> > in 3 easy steps.
> >
> > Connect with others.
> >
> > .
>
> I notice the same problem so i must return to 1.5.3 on linux sistem
>
> --
> ******************************************
> Ing. Matteo Cazzador
> Euronia Srl
> Stradone Porta Palio, 35
> 37122 Verona - Italy
> Email: matteo@...
> Web: http://www.euronia.it
> Personal Web Page: http://www.progettostema.it
> tel: 0459580680
> fax: 0459580681
> ******************************************
>