multiple connection string in web.config

[wild]

My development machine has Win XP pro and IIS 5.1
I have a 'default web site' with 2 virtual directories, let's say
'siteA' and 'siteB'.
Both point to the same application in the same phisical directory,
let's say C:\web\mysite.
In the 'web.config' file I have a key ('mysqlstring') that defines the
connection string to the database.
Is it possible to have two connection strings depending one the site I
use?
So if I came from 'http://localhost/siteA' I will use database 'A '
and if I came from 'http://localhost/siteB' I will use database 'B'
with the same application?
Thank you for your replay

[Eliyahu Goldin]

You have as many connection strings as you wish:

<connectionStri ngs>

<add name="Connectio nString1" connectionStrin g="..."/>

<add name="Connectio nString2" connectionStrin g="..."/>

</connectionStrin gs>

and in the code you can check the request url to decide what connection
string to use. Page.Request property points to the HttpRequest object that
in turn provides various url-related properties.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"wild" <wi*******@gmai l.comwrote in message
news:11******** **************@ z24g2000prh.goo glegroups.com.. .

My development machine has Win XP pro and IIS 5.1
I have a 'default web site' with 2 virtual directories, let's say
'siteA' and 'siteB'.
Both point to the same application in the same phisical directory,
let's say C:\web\mysite.
In the 'web.config' file I have a key ('mysqlstring') that defines the
connection string to the database.
Is it possible to have two connection strings depending one the site I
use?
So if I came from 'http://localhost/siteA' I will use database 'A '
and if I came from 'http://localhost/siteB' I will use database 'B'
with the same application?
Thank you for your replay

[wild]

On 24 Ott, 14:30, "Eliyahu Goldin"
<REMOVEALLCAPIT ALSeEgGoldD...@ mMvVpPsS.orgwro te:

You have as many connection strings as you wish:

<connectionStri ngs>

<add name="Connectio nString1" connectionStrin g="..."/>

<add name="Connectio nString2" connectionStrin g="..."/>

</connectionStrin gs>

and in the code you can check the request url to decide what connection
string to use. Page.Request property points to the HttpRequest object that
in turn provides various url-related properties.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]http://msmvps.com/blogs/egoldinhttp://usableasp.net

Thank you for your replay but I don't want to correct the code already
written in a lot of routines,
something like "Dim MyConn As New
OdbcConnection( ConfigurationSe ttings.AppSetti ngs("mySQLStrin g"))".
I was asking if it is possible to have two different 'config' files
depending on the requesting url, and leave the code unchanged.

[wild]

On 24 Ott, 14:30, "Eliyahu Goldin"
<REMOVEALLCAPIT ALSeEgGoldD...@ mMvVpPsS.orgwro te:

You have as many connection strings as you wish:

<connectionStri ngs>

<add name="Connectio nString1" connectionStrin g="..."/>

<add name="Connectio nString2" connectionStrin g="..."/>

</connectionStrin gs>

and in the code you can check the request url to decide what connection
string to use. Page.Request property points to the HttpRequest object that
in turn provides various url-related properties.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]http://msmvps.com/blogs/egoldinhttp://usableasp.net

Thank you for your replay but I don't want to correct the code already
written in a lot of routines,
something like "Dim MyConn As New
OdbcConnection( ConfigurationSe ttings.AppSetti ngs("mySQLStrin g"))".
I was asking if it is possible to have two different 'config' files
depending on the requesting url, and leave the code unchanged.

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

Did you have a look at asp.net configuration settings under virtual directory
properties in IIS?

Also, you could have two start pages, one for each virtual directory, which
sets the database connection.
Thanks
---------------------------
Thanks,
Ibrahim

Software Consultant - Web Development, GB
"wild" wrote:

On 24 Ott, 14:30, "Eliyahu Goldin"
<REMOVEALLCAPIT ALSeEgGoldD...@ mMvVpPsS.orgwro te:

You have as many connection strings as you wish:

<connectionStri ngs>

<add name="Connectio nString1" connectionStrin g="..."/>

<add name="Connectio nString2" connectionStrin g="..."/>

</connectionStrin gs>

and in the code you can check the request url to decide what connection
string to use. Page.Request property points to the HttpRequest object that
in turn provides various url-related properties.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]http://msmvps.com/blogs/egoldinhttp://usableasp.net

Thank you for your replay but I don't want to correct the code already
written in a lot of routines,
something like "Dim MyConn As New
OdbcConnection( ConfigurationSe ttings.AppSetti ngs("mySQLStrin g"))".
I was asking if it is possible to have two different 'config' files
depending on the requesting url, and leave the code unchanged.

[Reggie]

You could set the connection string as follows (air code). Then all you
have to do is run the replace command on the application to remove the
parenthesis around ("mySQLStrin g") so that its (mySQLString). So if you had
the following 2 connection strings:

<add name="Connectio nString1" connectionStrin g="..."/>
<add name="Connectio nString2" connectionStrin g="..."/>

Page_Load
Dim mySQLString As String
Dim strSite As String

strSite = Request.QuerySt ring("Site")

Select Case strSite
Case SiteA
mySQLString = "ConnectionStri ng1"
Case SiteB
mySQLString = "ConnectionStri ng2"
End Select

conn_str = ConfigurationSe ttings.AppSetti ngs(mySQLString )
conn = New SqlConnection(c onn_str)
conn.Open()

Hope this helps!
--

*************** ***
Reggie

"Ibrahim Shameeque" <Ib************ **@discussions. microsoft.comwr ote in
message news:9F******** *************** ***********@mic rosoft.com...

Did you have a look at asp.net configuration settings under virtual
directory
properties in IIS?

Also, you could have two start pages, one for each virtual directory,
which
sets the database connection.
Thanks
---------------------------
Thanks,
Ibrahim

Software Consultant - Web Development, GB
"wild" wrote:

>On 24 Ott, 14:30, "Eliyahu Goldin"
<REMOVEALLCAPI TALSeEgGoldD... @mMvVpPsS.orgwr ote:

You have as many connection strings as you wish:

<connectionStri ngs>

<add name="Connectio nString1" connectionStrin g="..."/>

<add name="Connectio nString2" connectionStrin g="..."/>

</connectionStrin gs>

and in the code you can check the request url to decide what connection
string to use. Page.Request property points to the HttpRequest object
that
in turn provides various url-related properties.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP
[ASP.NET]http://msmvps.com/blogs/egoldinhttp://usableasp.net

Thank you for your replay but I don't want to correct the code already
written in a lot of routines,
something like "Dim MyConn As New
OdbcConnection (ConfigurationS ettings.AppSett ings("mySQLStri ng"))".
I was asking if it is possible to have two different 'config' files
depending on the requesting url, and leave the code unchanged.