SQL DB Connection String

[Mugar]

I am curious if there is another way other than the example shown at http://www.dotnetjunkies.com/quickstart/util/srcview.aspx?path=/quickstart/aspplus/samples/webforms/intro/Intro8.src to access the connection string.<BR><BR>The way I have been doing it in "traditional" ASP is that I would stuff the connection username password etc into a .asp file and then call it as I need it in an SSI file.<BR><BR>I am using VS.NET IDE.<BR><BR>What is the best way to open the database when I need it in .NET?U can define your database connection string in Wed.Config file. <BR>Under <Configurations> Element put the code <BR><BR><appSettings><BR> <add key="DBConn" value=http://aspmessageboard.com/archive/index.php/"Server=urserver;User Id=sa;pwd=;Database=DBName" /><BR></appSettings><BR><BR>In the front end, define the he connection object syntax as <BR><BR>Set conn as New SQLConnection _<BR>(ConfigurationSettings.AppSettings("DBConn"))<BR><BR><BR>Krishnan.<BR>Ok, thanks.<BR><BR>I was not able to finde Wed.Config file.<BR>I just have remote access to my MaximumASP account.<BR><BR>Does that change things?<BR>appreciate it.<BR>---<BR>DanielHow do I edit and save the Web.Config file in VS.NET?<BR><BR><appSettings><BR><add key="Conn" value="DSN VALUE" /><BR></appSettings><BR><BR>When I tried to save the edit the server responded "Cannot save the file to the webserver. Forbidden"<BR><BR>What shall we do?<BR><BR>Thanks,<BR>DanielHi Daniel,<BR><BR>I haven't encountered such an error even though I modified web.config mnay times. Error may be the case sensitive nature of Web.config as it is XML based.<BR><BR>Krishnan.I tried this exact thing. I put this code in the webconfig file under the configuration and system.web tags.<BR><appSettings><BR> <add key ="DBConn" value ="Server=dev01; Database=exhibitManagement; UID=sa; PWD=money;" /><BR> </appSettings><BR><BR>Then I put this in the front end and I get nothing from the value.<BR><BR>Dim test As String<BR>test = (ConfigurationSettings.AppSettings("DBConn"))<BR>Response.Write("test" & test)<BR><BR>Any reason why? The response.write doesn't output anything past the test string