Hi,

We are extending an existing sales application. Unfortunately the
current deployed system's source code is not available and we have to
make extension as a separate application which will update the backend
database.

The problem is the sales application runs on multiple clients. We want
to make sure that the update queries etc go through our proxy, so that
we can maintain consistency in the database, as our new executable will
also be updating the data in the server.

Is there a way to hook SQL's connection and other queries somehow? Can
we replace the SQL connection driver installed on a machine with ours
which does this?

Thanks.
Ali

"al_nax" <ali (AT) uraan (DOT) com> wrote

Consider adding your own custom views and custom stored procedures; for data
retrieval or for data updates to the backend database. Business logic can be
added to the stored procedures (if needed) to update other tables based on
conditional logic.

If the SQL connection is exposed you should be able to re-use that, if not
create your own.

Steve