473,386 Members | 1,908 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

sql database connection string storage

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
Nov 18 '05 #1
5 941
You can store it in your web.config

Regards
Ganesh

"IntraRELY" <In*******@yahoo.com> wrote in message
news:eJ**************@TK2MSFTNGP14.phx.gbl...
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

Nov 18 '05 #2
You may want to store them in web.config. You can encrypt those entries too.
For a sample: http://support.microsoft.com/default...b;en-us;329290

"IntraRELY" <In*******@yahoo.com> wrote in message
news:eJ**************@TK2MSFTNGP14.phx.gbl...
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

Nov 18 '05 #3
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.)

Nov 18 '05 #4
The other post didnt show up in the reader and forgot to mention what I
was connecting to.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #5
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.)

Nov 18 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
9
by: jensendarren | last post by:
I just made a .NET Windows Application which uses MS Access as a backend. Is there a way to deploy the mdb file so that it does not appear as an Access db to the end user and still be accessable to...
27
by: Brett | last post by:
If I want to easily swap the database I'm using, what is the best method for developing that tier in my application? I'll have basically a 4 tier app: 1. presentation 2. business logic 3. data...
1
by: Ryan | last post by:
Is there an accepted strategy/design for database password management? Multiple asp.net web applications all talking to the same database. Each web app is on a separate machine and connectivity...
11
by: Jay King | last post by:
Ok I'm very new to the whole database thing, my problem is I'd like to use firebirds embeded database engine so I can just send it as some stand alone dlls to my user with my main program. I have...
1
by: ads | last post by:
how do i transfer database objects such as tables and sp to a database file in just clicks of a mouse? Originally we are using sql server 2000 as our data storage for a website but since the...
5
by: igotyourdotnet | last post by:
I'm trying to add a web part to my page and when I run my page with the web part I get this error: An error has occurred while establishing a connection to the server. When connecting to SQL...
2
by: Petra Chong | last post by:
Hello all I am using Python 2.3 and ZODB (without the rest of Zope) with the following pattern: * One process which writes stuff to a ZODB instance (call it test.db) * Another process which...
22
Frinavale
by: Frinavale | last post by:
How To Use A Database In Your Program Many .NET solutions are database driven and so many of us often wonder how to access the database. To help you understand the answer to this question I've...
1
Curtis Rutland
by: Curtis Rutland | last post by:
How To Use A Database In Your Program Part II This article is intended to extend Frinny’s excellent article: How to Use a Database in Your Program. Frinny’s article defines the basic concepts...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.