Hi,
We have a
requirement to convert(?) an existing application using Interbase to use SQL
Server or Interbase - we are using the IBX components
currently.
I see 3(2?) ways of
achieving this - having ruled out using the BDE.
1. Replace the IBX with ADO
components, using the same set of SQL statements etc for both SQL Server and
Interbase. My only query on this is finding a good enough Interbase ADO
driver/ODBC driver - suggestions?
2. Use class
factories etc and have both IBX and ADO components present, using the correct
set depending on the database installed.
3. Use the Delphi
Datasnap/dbExpress technology (I have not used this yet or investigated it yet -
so not certain if this is a starter). This needs a SQL Server and Interbase
driver to make this feasible - not yet using/installed D7
Your
comments, experiences and ideas are requested!
Thanks
Myles.
