<%@ Import Namespace=”System.Data” %>
<%@ Import Namespace=”System.Data.Odbc” %> <script
language=”C#” runat=”server”>
    void Application_Start()
    {
        //Connection string for SQL Server with trusted
connection
        Application.Add (”DB_CONNECTION_STRING”,”DRIVER={SQL
Server};SERVER=ServerName;DATABASE=DataBaseName;Trusted_connection=yes;”);
    }
    void Session_Start()
    {
        //open connection to database
        OdbcConnection  cnConnection = new OdbcConnection
(Application.Get(”DB_CONNECTION_STRING”).ToString());
        cnConnection.Open();
        Session.Add (”DB_CONNECTION”, cnConnection );
    }
    void Session_End()
    {
        //a graceful disconnect
        OdbcConnection cnConnection = (OdbcConnection)
Session["DB_CONNECTION"];
        cnConnection.Close ();
    }
</script>