how find identity of server

[oakgrove]

Hi all,
Is there a way (in the code) to find out the identity of the server that is running an aspx page? I need to have different connection strings for my development and my deployed machine. My idea is to have both strings in the code and specify the correct one at run time by reading the identity of the server. Does this sound like a workable idea?

 

[crazyboybert]

Hi Oakgrove

You can get the machine name from the server variables collection like this.

Request.ServerVariables["HTTP_HOST"]

However i would NOT recommend this approach for solvign your problem. In asp.net we can use the web.config file to stor configuration settings and then access them from the code. The config fiel is server specific and is not designed to be uploaded with every version of your application. An example web.config below with an appSetting containing a dummy dsn string...

<configuration>
	<appSettings>
	       <add key=&quot;DSN&quot; value=&quot;server=server;data source=database;user id=username;password=password&quot; />
	</appSettings>
	<system.web>
	</system.web>
</configuration>

You can access this from your code behind using...

System.Configuration.ConfigurationSettings.AppSettings["DSN"]

Hope this helps

Rob

Go placidly amidst the noise and haste, and remember what peace there may be in silence - Erhmann 1927

 

[stsuing]

<add key=&quot;ConnectionString&quot; value=&quot;data source=(local);initial catalog=DatabaseName;user id=xxxxxx;password=yyyyyyy&quot; />

This is also a valid connection string. If you have the application and SQL Server on the same machine this will work.

 

[oakgrove]

Thanks for your help I will go with the config idea. Should have thought of that first.
Thanks again