Re: Best method of saving data between the normal and SSL stuff
From: Laphan (news_at_DoNotEmailMe.co.uk)
Date: 03/16/04
- Next message: Laphan: "Re: Best way to add a pic and a thumbnail pic when creating a content management system"
- Previous message: Bob Barrows: "Re: Item cannot be found in the collection corresponding to the requested name or ordinal"
- In reply to: Aaron Bertrand [MVP]: "Re: Best method of saving data between the normal and SSL stuff"
- Next in thread: Aaron Bertrand [MVP]: "Re: Best method of saving data between the normal and SSL stuff"
- Reply: Aaron Bertrand [MVP]: "Re: Best method of saving data between the normal and SSL stuff"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 16 Mar 2004 22:24:07 -0000
Hi Aaron
Just to wrap this up, do you mean secure and non-secure in the same database
or as 2 completely separate ones?
I'd also appreciate your comments on the pluses and minuses of using MySQL
over SQL Server and vice versa.
Rgds
Laphan
Aaron Bertrand [MVP] <aaron@TRASHaspfaq.com> wrote in message
news:e$ubnC8BEHA.3804@TK2MSFTNGP09.phx.gbl...
I would use a central SQL Server to host both secure and non-secure data.
Security is another issue, of course. But replicating Access data, even on
the same server, is not something you want to deal with, trust me.
-- Aaron Bertrand SQL Server MVP http://www.aspfaq.com/ "Laphan" <news@DoNotEmailMe.co.uk> wrote in message news:Oo$CNh6BEHA.1456@TK2MSFTNGP09.phx.gbl... > Hi Guys > > Wonder if you could give me some tips on what the best way is re my problem. > > I'm currently using the session id with an Access DB table method to keep > hold of a shopping cart as the user goes through a site and then another > Access DB on my secure server to hold their address, contact and payment > details. > > What I want to do is store their completed orders so that they can look at > them anytime they want and I also want to allow them to store > wishlists/quotes so that they can store them and use them to order as and > when they want. > > I know these are not minor features and I don't want you to tell me exactly > how to do them (although that would be nice ;0). I just need your pointers > to make sure I'm going the right way about it. > > I know I could duplicate the data between the normal hosted Access DB and > the secure hosted Access DB to store this data, but if I'm going to use > MySQL or SQL Server do I basically call the same DB and the actual data that > is entered onto the web page is dealt with by the browser eg, the http and > https state? In otherwords do I need to worry that my https data is posted > to same http 'hit' DB? > > Is this how all MySQL/SQL Server DBs are used? > > Rgds > > Laphan > >
- Next message: Laphan: "Re: Best way to add a pic and a thumbnail pic when creating a content management system"
- Previous message: Bob Barrows: "Re: Item cannot be found in the collection corresponding to the requested name or ordinal"
- In reply to: Aaron Bertrand [MVP]: "Re: Best method of saving data between the normal and SSL stuff"
- Next in thread: Aaron Bertrand [MVP]: "Re: Best method of saving data between the normal and SSL stuff"
- Reply: Aaron Bertrand [MVP]: "Re: Best method of saving data between the normal and SSL stuff"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
