> I seems that both Interbase and Firebird run fine along side.
> I have a couple of questions:
> 1. For the IBX legacy apps to work properly, should the interbase
> gds32.dll
> by copied to the IBX application root directory.

Not the interbase one, but rather the version of gds32.dll created by
the Firebird Installer or by instclient.exe. Basically it is the same
as fbclient.dll, but it tricks the IBX components into connecting
happily to Firebird.

> 2. If it isn't, what database server will the application attempt to
> connect
> to if no port or service name is defined in the connection string

if both

> services are running at the same time. (is this governed by whatever
> gds32.dll the application is interfacing with?)

If you are using a TCP connection, then the server that you will be
talking to is the one listening to the port you connect to. IB / FB
both use 3050 by default (or if you dont explicitly define one). It
is not a good idea to use the IB client library against the FB server
and vice versa.

> 3. I have a database comparing application I have developed to

perform

> metadata changes for new versions of the application. 99% of the

app runs

> file using Firebird. However when attempting to create/alter certain
> stored
> procedures the following message it show:
> GetNumberStoredProcInput
> Dynamic SQL Error
> SQL Error Code = -104
> Invalid Expression in the ORDER BY clause (not contained in either

an

> aggregate function of the Group By Clause)

Post the query itself. I know that FB will let you order by a field
not in your resultset, but I do not know how this works with an
aggregate (sum / count / min / max / etc) involved.

All well written queries in IB 6 will work in FB, but where there may
be ambiguities FB will reject the query, where IB will accept it and
return something (that something may not be what you expected by the
way).

Adam