Re: question about proper production db/ado usage

From: Sean Nolan (seann_at_imgno%spaminc.com)
Date: 03/18/05 

Date: Fri, 18 Mar 2005 16:28:53 -0600

Yes there is :-)

You put the connection string in the appSettings section of the application
configuration file (web.config for an ASP.NET app) and read it with the
ConfigurationSettings.AppSettings property, see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpgrfaccessingappsettingssection.asp

Or in Visual Studio .NET you can use Dynamic Properties for a slightly more
hands-off approach, see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vboriintroductiontoapplicationsettingstorage.asp

For a more secure approach with ASP.NET apps (requires registry mods and a
downloadable utility) see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q329290

Sean

"Flip" <[remove_me]phenry_w@hotmail.com> wrote in message
news:uYZAdTALFHA.2540@TK2MSFTNGP10.phx.gbl...
>> Pooling is nicely described here:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconConnectionPoolingForSQLServerNETDataProvider.asp
>
>
> Thank you Sean for your feedback. Is there a standard/suggested way to
> create/use the connection strings in a web app?
>
> Thanks.
>

Relevant Pages

  • Re: Saving Back-End Data As mdf
    ... complete code of a VB.NET console app. ... It's just an example to illustrate how a connection string is used. ... so it doesn't appear to be a problem with how or what I install. ... you access to the Microsoft Office Online Beta site'. ...
    (microsoft.public.access.formscoding)
  • Re: Deployment + Vista
    ... this past week I had to deploy an app onto a small ... I'm not a big fan of using the app.config file to handle my server settings. ... to the app directory and then discard them upon exiting the form. ... function in order to put together the connection string something like: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access connection string (adp)
    ... will always be close by the last when leaving the app. ... Can I detect somehow the exit of my ADP? ... Just because I need to modify the connection string with a blank one, ... the connection string according to your post and then release and quit. ...
    (microsoft.public.access.formscoding)
  • Re: Security in windows forms apps
    ... On another note since this is an internal app I am not too worried about it ... You need to ensure that your not setting these values at design time. ... I have encrypted the connection string in the app.config file, ... rename the exe to .txt. So it will now be app.txt. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Deploy SQL Express so my app still works on other machines
    ... This all assumes that SQL Express is installed on the user's ... I have an app which uses an SQL Express database. ... Is it the format of my connection string within my app. ...
    (microsoft.public.sqlserver.msde)