Hi
I have been using Interbase 6.0.2.0 O/S for the last three years now.
We have found it very reliable even on multi-cpu / HT/ Windows 2003
machines
(thanks to ib_affinity).
We have been looking however at firebird and what would be involved in
porting to firebird but leaving (as much as possible anyway), the
application in-tact. The application is written in Delphi 6 Pro using IBX.
I recently installed Firebird 1.5 on a test box that originally had
Interbase 6.0.2.0 installed.
I created the client gds32.dll file as instructed, modified the conf file
and services file so that I now have gds_db on port 3050 and gds_fb on
port
3051.
I copied the original gds32.dll from interbase to the interbase\bin
directory and left the new gds32.dll (fbclient) in the system32
directory as
instructed.
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.
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?)
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)
Any help with any of all of the above would be appreciated.
Cheers
Dominic