persistent data source (light footprint, secure, supports sql query engine)

29 Jun 2005 1:08 PM

Jesse Aufiero

I am creating a vb.net app that displays historical financial data in
various ways (grids, charts, etc.). This data is sensitive and should only
be accessible through the vb.net application. The vb.net application must
also be able to issue sql select stmnts against the persistant data source
in order to get a wide variety of result sets back, for use in the
application's grids and charts.

How can I have my data in a completely secure place, and still have the
ability to issue sql stmnts against it?

SQL Server is not an option because the installation of my application must
be simple and 'lightweight'... and we're not talking about a massive amount
of data here.

Can an access database be embedded into the vb.net application? I would
rather not keep the .mdb outside the vb.net application because that is an
invitation to tampering and hacks.

Thanks!!

29 Jun 2005 1:53 PM

Marina

You can't embed it in an application, since you would have no way of writing
to it.

If you have simple SQL statements, maybe you can use an XML file and use
XPath to perform queries on it? An XML file can be encrypted and stored
securely.

Show quoteHide quote

"Jesse Aufiero" <jaufi***@moaboil.com> wrote in message
news:%23OFb0uKfFHA.1416@TK2MSFTNGP09.phx.gbl...
>I am creating a vb.net app that displays historical financial data in
>various ways (grids, charts, etc.). This data is sensitive and should only
>be accessible through the vb.net application. The vb.net application must
>also be able to issue sql select stmnts against the persistant data source
>in order to get a wide variety of result sets back, for use in the
>application's grids and charts.
>
> How can I have my data in a completely secure place, and still have the
> ability to issue sql stmnts against it?
>
> SQL Server is not an option because the installation of my application
> must be simple and 'lightweight'... and we're not talking about a massive
> amount of data here.
>
> Can an access database be embedded into the vb.net application? I would
> rather not keep the .mdb outside the vb.net application because that is an
> invitation to tampering and hacks.
>
> Thanks!!
>

1 Jul 2005 11:42 AM

Chad Z. Hower aka Kudzu

"Jesse Aufiero" <jaufi***@moaboil.com> wrote in
news:#OFb0uKfFHA.1416@TK2MSFTNGP09.phx.gbl:
> SQL Server is not an option because the installation of my application
> must be simple and 'lightweight'... and we're not talking about a
> massive amount of data here.
>
> Can an access database be embedded into the vb.net application? I
> would rather not keep the .mdb outside the vb.net application because
> that is an invitation to tampering and hacks.

Access is not a good choice. Try Firebird embedded version:
http://firebird.sourceforge.net/

You ship just ONE DLL - thats it.

Its free BTW,and open source.

--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Get your ASP.NET in gear with IntraWeb!
http://www.atozed.com/IntraWeb/