Re: Creating temporary database on user's PC.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dimitri Glazkov (dimitri.glazkov_at_gmail.com)
Date: 12/28/04


Date: Tue, 28 Dec 2004 09:59:19 -0600

Jerry,

You will not (and should not) be able to create a database on user's
computer. This goes against all principles of secure computing -- imagine
what would happen if other Web sites were be able to create files on your
hard drive at will.

There is a fundamental architectural difference in the way you approach Web
programming vs. Desktop. On the Web, the browser is a stateless serialized
view of the application.You can use things like cookies to simulate state,
but basically, the rule of thumb is that you store actual user data on the
server and only leave the identifying cookie with the user. When the user
logs in, your server reads the cookie and is able of retrieving user data
that corresponds with that cookie.

To implement authentication/authorization, I recommend looking into ASP.NET
Forms or Windows authentication.

>From there, you can develop a database, where user data is stored using user
Id as a key.

It's not a simple task, and I would highly recommend studying ASP.NET
architecture patterns before doing anything.

This is where MSDN library becomes your best friend.

:DG<

"Jerry Spence1" <jerry.spence@somewhere.com> wrote in message
news:41d17b42$0$74239$ed2619ec@ptn-nntp-reader03.plus.net...
>
> "Dimitri Glazkov" <dimitri.glazkov@gmail.com> wrote in message
> news:OJRNduO7EHA.2192@TK2MSFTNGP14.phx.gbl...
>> Could you explain the architecture of your program a little better? Why
>> are you creating this database? What will it be used for? By whom?
>>
>
> Thanks Dimitri
>
> My company produces its own IP Based security solution for surveillance
> and access control (Software and hardware). What I am trying to do is to
> create an interactive web site that will allow a prospective customer to
> select the card readers he needs (RFID, Card swipe etc), select the camera
> models (Infrared, Internal, Dome etc) and this will give him a list of
> parts with prices (including Power over Ethernet, Video over Ethernet
> components, video server etc). I was thinking of creating, on the fly, a
> database on his PC for temporarily storing his selected information (a bit
> like a relational 'basket' so that when he presses a button, he will get a
> complete list of parts, with quanities and total price for the whole
> project.
>
> I am sure there are probably other ways (and better) for doing this but I
> have no experience of Internet programming and don't know how it all
> normally fits together. I am an experienced VB.Net programmer though.
>
> I can't work out why I can't seem to create the database on the local PC
> drive and why I am getting that strange error message.
>
> Thanks
>
> -Jerry
>
>
>


Quantcast