sql database connection string storage

[IntraRELY]

I am building a standard ecomm shopping cart site. I usually store the
connection string w/in the code behind
page. I am not sure the best method is. I will be transferring the pages to
the live host after development and think that storing in a central location
maybe of benefit, so I do not have to make changes on 20 pages. However, I
only have to do it once and could simply use a find and replace very easily.
I
am looking for both a secure and easy solution.


TIA,

Steve

 

[Ganesh Ramamurthy]

You can store it in your web.config

Regards
Ganesh

 

[Shiva]

You may want to store them in web.config. You can encrypt those entries too.
For a sample: http://support.microsoft.com/default.aspx?scid=kb;en-us;329290

I am building a standard ecomm shopping cart site. I usually store the
connection string w/in the code behind
page. I am not sure the best method is. I will be transferring the pages to
the live host after development and think that storing in a central location
maybe of benefit, so I do not have to make changes on 20 pages. However, I
only have to do it once and could simply use a find and replace very easily.
I
am looking for both a secure and easy solution.


TIA,

Steve

 

[Steven Cheng[MSFT]]

Hi Steve,

Thanks for your posting. As for this post, I've noticed your another
threads in this newsgroup, some other members and I have posted our reply
and suggestions there. I'd appreciate if you also have a look there. also,
if you feel it convenient that we continue to discuss this problem is that
thread, please feel free to post here. Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

 

[Steve Wofford]

The other post didnt show up in the reader and forgot to mention what I
was connecting to.

 

[Steven Cheng[MSFT]]

Hi Steve,

I've also noticed your response in the other thread. I'll post my response
there, please feel free to followup there. Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)