Sorry for not coming back earlier - but thanks for the help.

I do have another query that has popped up since.

I have tried installing FB 2.1.3 64 bit on a Windows 2008 server, and have copied our existing UDF files into the UDF directory, but when the SQL script that creates the databases runs, it generates an error about function not existing.

I used to get this on a 32 bit installation of Firebird whenever I forgot to copy the UDF files into the directory.

Is there a problem using 32bit compiled UDF's in a 64 bit installation of Firebird? The UDF's work fine if I install the 32 bit Firebird on the 64 bit server, so it must be something to do with the 64 bit installation of Firebird not being able to talk to the 32 bit UDF?

Any help appreciated.

Again, sorry if its a dumbass question, but we are only just venturing into the realm of supporting 64bit servers :)

--- In firebird-support@yahoogroups.com, "Mark Rotteveel" <Avalanche1979@...> wrote:
>
> > So, going by this answer, we would continue to use the 32 bit version of
> > fbclient.dll, regardless of whether the installed Firebird is 32bit or 64
> > bit.
>
> If your applications remain 32 bit, using the 64 bit fbclient.dll would make them stop working, as 32 bit applications cannot use 64 bit DLLs (and vice versa).
>
> > I guess the question is, is there any real benefit of installing the 64
> > bit version of Firebird on 64 bit servers, when the applications will be
> > remaining as 32 bit?
>
> Of course there is: you can use more memory on the server. That is usually the major benefit. Sometimes applications can be (slightly) faster on 64 bit (on the other hand they could also be (slightly) slower), I just don't know if that applies to Firebird.
>
> Mark
> --
> Sicherer, schneller und einfacher. Die aktuellen Internet-Browser -
> jetzt kostenlos herunterladen! http://portal.gmx.net/de/go/atbrowser
>