Different connection strings for different web servers

[=?Utf-8?B?UGF0Qg==?=]

Is there a way in ASP.NET 2.0 to have different connection strings settings
in a web.config files that are dynamically used based upon the server that
the web application is running on?

For example, you have have two test web servers (TEST1 and TEST2) and a
production web server (PROD1). Each of these connection to a different
database for general data access and for membership/role providers.

<connectionStri ngs>
<add name="Test1DB" connectionStrin g="Data Source=Test1DBS erver;Initial
Catalog=MyApp;U ser Id=User;Passwor d=password;" />
<add name="Test2DB" connectionStrin g="Data Source=Test2DBS erver;Initial
Catalog=MyApp;U ser Id=User;Passwor d=password;" />
<add name="Prod1DB" connectionStrin g="Data Source=Prod1DBS erver;Initial
Catalog=MyApp;U ser Id=User;Passwor d=password;" />
</connectionStrin gs>

....

<providers>
<add name="Customize dMembershipProv ider"
type="System.We b.Security.SqlM embershipProvid er"
connectionStrin gName="Prod1DB"
applicationName ="MyApp"
minRequiredPass wordLength="5"
minRequiredNona lphanumericChar acters="0" />
</providers>

If this application is running on my production server (PROD1) all is well
as the provider is set to use the Prod1DB connection string. However, if the
application is running on my TEST1 web server, how do I programmaticall y
change the connectionStrin gName setting to the Test1DB connection string?

Thanks,

--
Pat B
BCC Software, Inc
A BÖWE BELL + HOWELL COMPANY

[Mark Rae [MVP]]

"PatB" <Pa**@community .nospamwrote in message
news:D5******** *************** ***********@mic rosoft.com...

Is there a way in ASP.NET 2.0 to have different connection strings
settings
in a web.config files that are dynamically used based upon the server that
the web application is running on?

Yep - have a look at System.Environm ent.MachineName , and name your various
connection strings accordingly...

Alternatively, have a look at:
http://msdn2.microsoft.com/en-us/asp.net/aa336619.aspx

--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[=?Utf-8?B?UGF0Qg==?=]

Mark,

I have done exactly as you stated in ASP.NET 1.1 by preferencing my
connection string names with the machine name. Then in the Application_Sta rt
method I set a connection string variable to the appropriate connection
string from the web.config file.

This works great for a connection string that I am going to be using for
data access within my code.

But what about for the membership/role providers where the
connectionStrin gName is specified in the web.config file. Can I dynamically
change the provider's connectionStrin gName in the Application_Sta rt method?
If so how do I do that? (tried but couldn't figure it out).

Please pardon my lack of knowledge with ASP.NET 2.0. It's my first attempt
at using ASP.NET 2.0.

Thank you,

--
Pat B
BCC Software, Inc
A BÖWE BELL + HOWELL COMPANY
"Mark Rae [MVP]" wrote:

"PatB" <Pa**@community .nospamwrote in message
news:D5******** *************** ***********@mic rosoft.com...

Is there a way in ASP.NET 2.0 to have different connection strings
settings
in a web.config files that are dynamically used based upon the server that
the web application is running on?

Yep - have a look at System.Environm ent.MachineName , and name your various
connection strings accordingly...

Alternatively, have a look at:
http://msdn2.microsoft.com/en-us/asp.net/aa336619.aspx

--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"PatB" <Pa**@community .nospamwrote in message
news:6D******** *************** ***********@mic rosoft.com...

I have done exactly as you stated in ASP.NET 1.1 by preferencing my
connection string names with the machine name. Then in the
Application_Sta rt
method I set a connection string variable to the appropriate connection
string from the web.config file.

This works great for a connection string that I am going to be using for
data access within my code.

OK.

But what about for the membership/role providers where the
connectionStrin gName is specified in the web.config file. Can I
dynamically
change the provider's connectionStrin gName in the Application_Sta rt
method?
If so how do I do that? (tried but couldn't figure it out).

Ah - I have to confess that I don't know for certain without some
experimenting of my own - I never use any of the Membership stuff...

However, Web Deployment Projects would *certainly* do this for you because
it allows different builds to replace various sections of the web.config
file...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

PatB,
This should be helpful:
http://www.eggheadcafe.com/tutorials...-configur.aspx

-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder( BETA): http://www.blogmetafinder.com

"PatB" wrote:

Is there a way in ASP.NET 2.0 to have different connection strings settings
in a web.config files that are dynamically used based upon the server that
the web application is running on?

For example, you have have two test web servers (TEST1 and TEST2) and a
production web server (PROD1). Each of these connection to a different
database for general data access and for membership/role providers.

<connectionStri ngs>
<add name="Test1DB" connectionStrin g="Data Source=Test1DBS erver;Initial
Catalog=MyApp;U ser Id=User;Passwor d=password;" />
<add name="Test2DB" connectionStrin g="Data Source=Test2DBS erver;Initial
Catalog=MyApp;U ser Id=User;Passwor d=password;" />
<add name="Prod1DB" connectionStrin g="Data Source=Prod1DBS erver;Initial
Catalog=MyApp;U ser Id=User;Passwor d=password;" />
</connectionStrin gs>

...

<providers>
<add name="Customize dMembershipProv ider"
type="System.We b.Security.SqlM embershipProvid er"
connectionStrin gName="Prod1DB"
applicationName ="MyApp"
minRequiredPass wordLength="5"
minRequiredNona lphanumericChar acters="0" />
</providers>

If this application is running on my production server (PROD1) all is well
as the provider is set to use the Prod1DB connection string. However, if the
application is running on my TEST1 web server, how do I programmaticall y
change the connectionStrin gName setting to the Test1DB connection string?

Thanks,

--
Pat B
BCC Software, Inc
A BÖWE BELL + HOWELL COMPANY

[=?Utf-8?B?UGF0Qg==?=]

Peter,

That does sound as if it would solve my problem. I will have to experiment
with this as I build my site.

Thank you!

--
Pat B
BCC Software, Inc
A BÖWE BELL + HOWELL COMPANY
"Peter Bromberg [C# MVP]" wrote:

PatB,
This should be helpful:
http://www.eggheadcafe.com/tutorials...-configur.aspx

-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder( BETA): http://www.blogmetafinder.com

"PatB" wrote:

Is there a way in ASP.NET 2.0 to have different connection strings settings
in a web.config files that are dynamically used based upon the server that
the web application is running on?

For example, you have have two test web servers (TEST1 and TEST2) and a
production web server (PROD1). Each of these connection to a different
database for general data access and for membership/role providers.

<connectionStri ngs>
<add name="Test1DB" connectionStrin g="Data Source=Test1DBS erver;Initial
Catalog=MyApp;U ser Id=User;Passwor d=password;" />
<add name="Test2DB" connectionStrin g="Data Source=Test2DBS erver;Initial
Catalog=MyApp;U ser Id=User;Passwor d=password;" />
<add name="Prod1DB" connectionStrin g="Data Source=Prod1DBS erver;Initial
Catalog=MyApp;U ser Id=User;Passwor d=password;" />
</connectionStrin gs>

...

<providers>
<add name="Customize dMembershipProv ider"
type="System.We b.Security.SqlM embershipProvid er"
connectionStrin gName="Prod1DB"
applicationName ="MyApp"
minRequiredPass wordLength="5"
minRequiredNona lphanumericChar acters="0" />
</providers>

If this application is running on my production server (PROD1) all is well
as the provider is set to use the Prod1DB connection string. However, if the
application is running on my TEST1 web server, how do I programmaticall y
change the connectionStrin gName setting to the Test1DB connection string?

Thanks,

--
Pat B
BCC Software, Inc
A BÖWE BELL + HOWELL COMPANY

[Steven Cheng[MSFT]]

Hi Pat,

Yes, for ASP.NET 2.0 web application, if you want to use different
connectionstrin gs for different scenario, all the available approaches are
as below:

** add multiple connectionstrin gs and load them dynamically in code depend
on which one to use

** use Web Deployment project, thus, you can choose to set the certain c
onfiguration section(such as connectionstrin g) to a specifc value at
precompile/publish time. However, after that , the application still
statically load the fixed connectionstrin g from web.config file

http://weblogs.asp.net/scottgu/archi...06/429723.aspx

** .NET 2.0 configuration file provide a "configSour ce" which can let you
define the content of a configuration section in a separate file. Thus, you
can define multiple separate files(contains connectionstrin gs for different
scenarios) and change your main web.config file to use the certain one
depend on which one will be used:

#SectionInforma tion.ConfigSour ce Property
http://msdn2.microsoft.com/en-us/lib...sectioninforma
tion.configsour ce.aspx

#ASP Net - if statement in web.config file
http://www.velocityreviews.com/forum...webconfig-file
html

Anyway, so far web.config file doesn't direcctly support dynamic (or
if...else... like) loading mechanism.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

[Mark Rae [MVP]]

"Steven Cheng[MSFT]" <st*****@online .microsoft.comw rote in message
news:ZD******** ******@TK2MSFTN GHUB02.phx.gbl. ..

Hi Pat,

Your newsreader continues to post your messages in the wrong place in the
thread...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[=?Utf-8?B?UGF0Qg==?=]

Mark,

What are you talking about? They seem to be in the right place to me.

I am using the Microsoft browser newsreader.

--
Pat B
BCC Software, Inc
A BÖWE BELL + HOWELL COMPANY
"Mark Rae [MVP]" wrote:

"Steven Cheng[MSFT]" <st*****@online .microsoft.comw rote in message
news:ZD******** ******@TK2MSFTN GHUB02.phx.gbl. ..

Hi Pat,

Your newsreader continues to post your messages in the wrong place in the
thread...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"PatB" <Pa**@community .nospamwrote in message
news:0C******** *************** ***********@mic rosoft.com...

What are you talking about? They seem to be in the right place to me.

Steven's reply to you appeared under my previous post i.e. as if he was
replying to me, not you...

I am using the Microsoft browser newsreader.

I'm using Windows Mail
--
Mark Rae
ASP.NET MVP
http://www.markrae.net