BorlandTalk.com

CAMAMagnet · Guest

Hello,

We have a two tier application that currently communicates with a
Firebird Database.

This database includes alot of Tables and Stored Procedures. Many of
the calls to stored procedures are being done with TQuery Components
(Select * from StoredProcedure(:Pram1, :Pram2)).

We have clients that would like us to support SQL Server. SQL Server
does not support the syntax Select * from StoredProcedure.

We would like to find a way to support both Databases. Has anyone else
had to do anything similiar?

Our thoughts are:

1) Stay with the BDE and find a way to change application to support
both databases.
2) Move to ODBC (or DBExpress or something) and find a way to change
application to support both databases.
3) Move to a 3 tier application and move all of the business code that
is currently in Stored Procedures into a middle layer outside of the
database.

Ideally, we would like to do option 1, but this seems to be alot of work
based on the size of our application. Number 2 is also alot of work but
probably makes sense. Number 1 should be the easiest, but might not
even be possible.

Any insight into how we can make this decision would be greatly appreciated.

Todd (todd@compass-cama.com)