Subject Re: Versioning Question
Author Eduardo A
--- In, "Craig Cox" <Craig_Cox@...> wrote:
> Can different versions of the Firebird client coexist on the 'client' side?
> Can different versions of the Firebird server coexist on the server side?

You'll probably get more details from others but, as far as I know, the 1.5 and 2.x servers can coexist. Some 2.x servers recommend that you uninstall any previous version 2.x servers before installing the newer version.

In the case of the clients, that is where the problems come. Firebird 2.1 on are built by the Microsoft MSVC8 compiler in Visual Studio 2005. Because all the Firebird binaries are built to use dynamic linking, they all require run-time libraries. So the client DLL (FBCLIENT.DLL) requires additional DLLs from MS redistributables to run. And, as of now, there is no easy installer for the newer FBCLIENTs and their MS Redistributables for each client PC.

So not all FBCLIENT.DLLs are the same.

I've created my own "one-time" installer for all the clients which installs an FBCLIENT.DLL and, in case they are needed, a GDS32.DLL and calls the MS Redistributable MSI to install the right DLLs in the correct places so we do not have to distribute them with each of our apps. I am sure you can do the same.

Migration from 1.5.x to 2.5.x takes several steps which include the upgrading of the security.fdb page sizes and renaming of the database itself to security2.fdb. In addition some scripts have to be run against that database. So it is not as simple as doing another server install and supporting both at the same time takes some flexibility.

The Generators (now called Sequence) are 64 bits but, if you assign the result to an INTEGER they are truncated to the lower 32 bits.

Of course, your mileage may vary.