--- In IBObjects@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:

>
> Jason,
>
> >> I have uploaded a test project to the files area of this group. File name
> >> is ibotest.zip.
> >>
> >> If you run this using FB 2.1.3 on Windows 7 it works. If you run it using
> >> FB2.0.? on Linux (version reported by IB_SQL = LI-V6.3.5.13206 Firebird
> >> 2.0) it will fail.
> >>
> >> To run the project you will have to change the server and path properties
> >> of the TIB_Connection to point to the place where you put the test
> >> database on your system, compile the project and run it. First click the
> >> Insert button. Then click the update button. It will fail when you click
> >> Update.
> >
> > This sounds like an issue in regard to how Firebird handles statements. It's
> > rather awkward for me to be swapping versions of Firebird on my current
> > system. I wonder if you would do a test for me and see if it is submitting
> > the exact same statement to each different version or if IBO produces a
> > different statement depending on the version of server it is connecting to.
>
> You can easily run several Firebird instances side-by-side as an
> application. The client application then simply needs to provide the
> proper port information in the connect string to connect to right instance.

It is also absolutely possible to run FB in virtual machines. The client machine will have it's own ip adress. This is currently not the way I do things because my clients (customers) are 2.0 or 2.1 and as Thomas says these versions are fine running as applications. I used this mode when working with a hard-core linux team some years back that had the need for custom UDFs that I wrote for linux only. I had ubuntu in a VM and accessed the database from the host using the IP that the client machine exposes. This is a neat way to keep things absolutely separated. I also think that there are VM software (oracle?) that are free out there, especially when you run linux.

HTH,

/Dany