ASP.NET web.config configuration
<p>I need to know how to configure my asp.net web.config file so that is has connection string to my database.  Here is the code I have in the file at this time:</p>

<pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;configuration&gt;
    &lt;system.webServer&gt;
        &lt;tracing&gt;
            &lt;traceFailedRequests&gt;
                &lt;add path="*.asp"&gt;
                    &lt;traceAreas&gt;
                        &lt;add provider="ASP" verbosity="Verbose" /&gt;
                        &lt;add provider="ASPNET" areas="Infrastructure,Module,Page,AppServices" verbosity="Verbose" /&gt;
                        &lt;add provider="ISAPI Extension" verbosity="Verbose" /&gt;
                        &lt;add provider="WWW Server" areas="Authentication,Security,Filter,StaticFile,CGI,Compression,Cache,RequestNotifications,Module,FastCGI" verbosity="Verbose" /&gt;
                    &lt;/traceAreas&gt;
                    &lt;failureDefinitions statusCodes="500" /&gt;
                 &lt;/add&gt;
            &lt;/traceFailedRequests&gt;
        &lt;/tracing&gt;
        &lt;handlers&gt;
            &lt;remove name="AboMapperCustom-66406" /&gt;
        &lt;/handlers&gt;
        &lt;httpErrors errorMode="DetailedLocalOnly"&gt;
            &lt;remove statusCode="412" subStatusCode="-1" /&gt;
            &lt;remove statusCode="404" subStatusCode="-1" /&gt;
            &lt;error statusCode="404" path="/handle404.asp" responseMode="ExecuteURL" /&gt;
        &lt;/httpErrors&gt;
    &lt;/system.webServer&gt;
&lt;/configuration&gt;
</code></pre>

<p>The connection string I need to integrate is as follows:</p>

<pre><code>server=214187-1;database=storeboard;uid=stuser;pwd=MyPassword
</code></pre>

<p>The connection string is required for the following page:</p>

<pre><code>&lt;%@ Page Language="VB" EnableSessionState="True" %&gt;
&lt;%@Import Namespace="System" %&gt;
&lt;%@Import Namespace="System.Data" %&gt;
&lt;%@Import Namespace="System.Data.SqlClient" %&gt;
&lt;%@Import Namespace="System.Configuration" %&gt;
&lt;%@Import Namespace="System.web" %&gt;
&lt;%@Import Namespace="System.Net" %&gt;
&lt;%@Import Namespace="System.Net.Mail" %&gt;
&lt;%@Import Namespace="System.Security.Cryptography" %&gt;
&lt;%@Import Namespace="System.Text" %&gt;

    &lt;script language="vbscript" runat="server"&gt;
    Dim UserName As String
    Dim oConn As SqlConnection
    Dim oCmd1 As SqlCommand
    Dim oCmd2 As SqlCommand
    Dim oCmd3 As SqlCommand
    Dim aConfig As ConfigurationSettings
    Dim strConn As String
    Dim strSQL As String
    Dim LastActivity As string 
    Dim ToAddress As String
    Dim ToName As String
    Dim BatchMailID as Integer
    Dim SessionID As String
    Dim Subject As String
    Dim Inactive as Boolean
    Dim Message As String
    Dim StillActive As Boolean = False

    Dim G_COOKIEROOT AS String = "STOREBOARD"



    Private Sub Page_Load()
        Dim dr As SqlDataReader

        SessionID = Request.Cookies(G_COOKIEROOT)("SESSIONID")
        Session("SessionID") = SessionID
        Response.Cookies(G_COOKIEROOT)("SESSIONID") = SessionID

        strConn = ConfigurationManager.AppSettings("ConnectionString")
        oConn = New SqlConnection(strConn)


        oConn.Open()
        If Trim(SessionID &amp; "") &lt;&gt; "" Then
            strSQL = "sp_SessionData @MODE='UPDATEACTIVITY',@SessionID='" &amp; SessionID &amp; "'"
            oCmd1 = New SqlCommand(strSQL, oConn)
            dr = oCmd1.ExecuteReader()
            While dr.Read()
                StillActive = dr("StillActive")
            End While
            dr.Close()

        End If


    End Sub





&lt;/script&gt;
&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
&lt;html xmlns="http://www.w3.org/1999/xhtml" &gt;
&lt;head&gt;
&lt;title&gt;ASP.NET Status Checker&lt;/title&gt;
&lt;meta http-equiv="refresh" content="60" /&gt;
&lt;/head&gt;
&lt;body&gt;
SessionID: &lt;%=SessionID%&gt;&lt;br/&gt;
&lt;%=Now()%&gt;
&lt;/body&gt;
&lt;/html&gt;
</code></pre>

<p>Any help with this issue would be greatly appreciated...</p>

<p>Best Regards,
Paul</p>
