[fpc-pascal] proxy for sql
Michael Van Canneyt
michael at freepascal.org
Thu Mar 19 15:22:21 CET 2009
On Thu, 19 Mar 2009, Andreas Berger wrote:
> This isn't really a FPC question, but since the application is being written
> in FPC I thought I would ask here.
> I am developing an application that controls machinery. The application will
> store everything that happens in a SQL database. Some clients (restricted)
> should have permission to access the database to generate their own reports
> via some 3rd party report generation software of their choice. However I want
> to restrict who has access without placing a user password on the SQL server
> since some clients purchase multiple instances of the SW but not all options.
> 1) Is it possible to place my app between the 3rd party app and the SQL
> server? How would I do this.
I seriously doubt this, unless you write an ODBC driver that connects to
your application instead of the database.
There is no way to know in advance what tool the user will use, and ODBC
is more or less the only standard that most reporting tools support...
> 2) Is it possible to configure the SQL server to query my app to see if a user
> can log on?
That depends on the database and how your login is defined. In e.g. firebird, I
don't think this is possible.
IMHO Your best shot is to force a particular reporting tool. I have very good
experiences with FastReport, however it currently does not work with FPC.
More information about the fpc-pascal