[thelist] DSN Less to DSN (XML thanks to all)

[Robert Goodyear]

I use an include file so I can make global changes to the db connection. I also set a
variable in the include that tells the application what type of db it is (Access vs. SQL)
so I can do if...then branches for query syntax accuracy.

/rg


--- sgd <sgd at ti3.com> wrote:
> 
> > I just finished an E-commerce site and I do have a problem...
> > The whole site was developed as a DSN Less site and I am now wondering
> > how to convert it to DSN and secure the e-store properly.
> 
> Not really a security issue, unless you're exposing the connection string to
> the browser er something. --Citing performance as the reason is debatable
> (I've seen good arguments on both sides), but I'd say going to a DSN is a
> Good Thing, simply because of the management (centralized).
> 
> > Does it involve a lot of changes to the code? Do I have to have any
> > information provided by the host? 
> 
> Oh! You're hosted --you may be hosed. Your host will have to set up the DSN,
> and they may or may not want to do that. Yer gonna hafta check with them.
> Also keep in mind that depending on the kind of DSN set up and how your host
> has got things configured, /other people/ hosted there may have access to
> it. I've not gone down the road of setting up an MS-based ISP like this, so
> I'm not sure of all the implications, but I'd get a super-dude at your ISP
> on the phone and ask him/her 'bout it. (Yes, paranoia is a good thing)
> 
> Hand-waving aside-- I'd throw the connection string into your global.asa's
> Application_OnStart routine, setting an Application scope variable to it,
> and go home for the day.
> 
> sgd


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/