Solved

Classic ASP, IIS 8 with SQL Server 2008 Express - one page keeps logging the user out on page load

Posted on 2015-02-09
4
225 Views
Last Modified: 2015-02-11
HI,

I have a strange problem. Had a stable, well-running classic ASP application on an older Win 2008 web server that failed.

We recovered the database and application files and deployed them on a new Windows 2012 server (no choice, long story).

The application seems to be working, but there is one page - a critical page - that appears to be killing the user session state on page load. So when the user goes to save their form submittal, they just get the login page. This is true even if they just go to this page, and hit refresh.

Has anyone heard of this sort of thing? Other pages, presumably with more complicated programming are writing, modifying and deleting records as expected, but this one page no longer lets us do anything.

I've attached the page. (Actually it wouldn't let me attach ASP file - sorry for the long code paste:

<%@LANGUAGE="VBSCRIPT"%>
<%
' functions are typically at the top or bottom of your page.
function checkIT(user_type,valueToCheckInclude, valueToCheckExclude)
     checkInclude=false
     checkExclude=true
     arrUsertype=split(user_type,",")
     for each number in arrUsertype
          if cstr(number)=cstr(valueToCheckInclude) then
               checkInclude=true
         end if
         if cstr(number)=cstr(valueToCheckExclude) then
               checkExclude=false
         end if

    next
    if checkInclude = true And checkExclude = true then
     checkIT = true
   else
     checkIT = false
   End if
end function

function checkIT2(user_type2,valueToCheckInclude2, valueToCheckExclude2)
user_type2=replace(user_type2," ","")
	if instr(","& user_type2 &",",","& valueToCheckInclude2 &",")>0 AND instr(","& user_type2 &",",","& valueToCheckExclude2 &",")=0 then
		checkIT2=True
	else
		checkIT2=False
	end if
end function
%>
<!--#include file="Connections/mande2.asp" -->
<%
set oCon = server.CreateObject("ADODB.Connection")
    oCon.open MM_mande_STRING
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers=""
MM_authFailedURL="login_redirect.asp"
MM_grantAccess=false
If Session("MM_Username") <> "" Then
  If (true Or CStr(Session("MM_UserAuthorization"))="") Or _
         (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
    MM_grantAccess = true
  End If
End If
If Not MM_grantAccess Then
  MM_qsChar = "?"
  If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
  MM_referrer = Request.ServerVariables("URL")
  if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
  MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
  Response.Redirect(MM_authFailedURL)
End If

Dim UserRegion
Dim UserRegion_cmd
Dim UserRegion_numRows

Set UserRegion_cmd = Server.CreateObject ("ADODB.Command")
UserRegion_cmd.ActiveConnection = MM_mande_STRING
UserRegion_cmd.CommandText = "SELECT * FROM Regions where clientid = "&Session("clientid")&"  ORDER BY regionname DESC" 
UserRegion_cmd.Prepared = true

Set UserRegion = UserRegion_cmd.Execute
UserRegion_numRows = 0
%>

<%
Dim User__MMColParam
User__MMColParam = "1"
If (Session("MM_Username") <> "") Then 
  User__MMColParam = Session("MM_Username")
End If
%>
<%
Dim User
Dim User_cmd
Dim User_numRows

Set User_cmd = Server.CreateObject ("ADODB.Command")
User_cmd.ActiveConnection = MM_mande_STRING
User_cmd.CommandText = "SELECT * FROM Users WHERE clientid = "&Session("clientid")&" and  UserName = ?" 
User_cmd.Prepared = true
User_cmd.Parameters.Append User_cmd.CreateParameter("param1", 200, 1, 255, User__MMColParam) ' adVarChar

Set User = User_cmd.Execute
User_numRows = 0
%>
<%
Dim summary
Dim summary_cmd
Dim summary_numRows

Set summary_cmd = Server.CreateObject ("ADODB.Command")
summary_cmd.ActiveConnection = MM_mande_STRING
summary_cmd.CommandText = "SELECT Users.UserID, Users.UserFirstName, Sum(Jobs.AcceptedPrice) AS SumOfsalevalue, Avg(Jobs.AcceptedPrice) AS AvgOfsalevalue FROM Users INNER JOIN Jobs ON Users.UserID = Jobs.EstimatorAssigned GROUP BY users.userid, Users.UserFirstName" 
summary_cmd.Prepared = true

Set summary = summary_cmd.Execute
summary_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
summary_numRows = summary_numRows + Repeat1__numRows
%>
      
<!doctype html>
<html xml:lang="en-gb" lang="en-gb" >
<head>
			<meta name="viewport" content="width=device-width, initial-scale=1.0">
        <%
set which = oCon.execute("SELECT Server FROM Which")
%>

<% whichserver=(which("Server"))%>
  <base href="<% =whichserver %>" />
  <meta http-equiv="content-type" content="text/html; charset=utf-8" />
  <title><%=session("compname")%> Powered by Simple Source CRM v4</title>
  <link href="<% =whichserver %>" rel="canonical" />

  <link rel="stylesheet" href="/templates/rt_stratos/css-compiled/menu-296f9540b6fdbc3d0fa92e37d50106a1.css" type="text/css" />
  <link rel="stylesheet" href="/libraries/gantry/css/grid-responsive.css" type="text/css" />
  <link rel="stylesheet" href="/templates/rt_stratos/css-compiled/bootstrap.css" type="text/css" />
  <link rel="stylesheet" href="/templates/rt_stratos/css-compiled/master-10d632fb5e871d124a63de7b89359a4a.css" type="text/css" />
  <link rel="stylesheet" href="/templates/rt_stratos/css-compiled/mediaqueries.css" type="text/css" />

  <link rel="stylesheet" href="/templates/rt_stratos/css/rt_stratos-custom.css" type="text/css" />
  <style type="text/css">
#rt-logo {background: url(/images/logo_final2.png) 50% 0 no-repeat !important;}
#rt-logo {width: 350px;height: 45px;}
.rt-grid-6 {width: 370px;}
.icon-help-huge:before  {color:#333;}
@media (max-width: 480px) { 
#rt-mainbody {margin-top:-100px;}
 }

/* Smartphones to Tablets */
@media (min-width: 481px) and (max-width: 767px) {
#rt-mainbody {margin-top:-100px;}
 }

/* Tablets */
@media (min-width: 768px) and (max-width: 959px) { 
.menu-block{width:960px;}
 }

/* Desktop */
@media (min-width: 960px) and (max-width: 1199px) { 
.menu-block{width:1100px;}
}

/* Large Display */
@media (min-width: 1200px) { 
.menu-block{width:1100px;}
 }

  </style>
  <script src="/media/system/js/mootools-core.js" type="text/javascript"></script>
  <script src="/media/system/js/core.js" type="text/javascript"></script>
  <script src="/media/system/js/mootools-more.js" type="text/javascript"></script>
  <script src="/plugins/system/rokbox/assets/js/rokbox.js" type="text/javascript"></script>

  <script src="/templates/rt_stratos/js/rokmediaqueries.js" type="text/javascript"></script>
  <script src="/modules/mod_roknavmenu/themes/default/js/rokmediaqueries.js" type="text/javascript"></script>
  <script src="/modules/mod_roknavmenu/themes/default/js/responsive.js" type="text/javascript"></script>
  <script type="text/javascript">
if (typeof RokBoxSettings == 'undefined') RokBoxSettings = {pc: '100'};

  </script>
  <script type="text/javascript">
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
</script>
<script>
function changeColour(elementId) {
    var interval = 1000;
    var colour1 = "#ff0000"
    var colour2 = "#000000";
    if (document.getElementById) {
        var element = document.getElementById(elementId);
        //element.style.color = (element.style.color == colour1) ? colour2 : colour1;
        setTimeout("changeColour('" + elementId + "')", interval);
    }
}
//-->
</script>
	




 

</head>
<body  onLoad="changeColour('flashtext')" class="logo-type-custom background-overlay-light background-type-light-diagonal-strips header-overlay-dark main-body-light font-family-stratos font-size-is-default menu-type-dropdownmenu layout-mode-responsive col12 option-com-content menu-sign-up ">
<div id="bodyFilm"></div>



<input type="hidden" name="HUserType" id="HUserType" value="<%=Session("UserType")%>"  />

	<div id="rt-page-surround">
				<header id="rt-top-surround">
						<div id="rt-drawer">
				<div class="rt-container">
										<div class="clear"></div>
				</div>
			</div>
						
									<div id="rt-header">
				<div class="rt-container">
					<div class="rt-grid-6 rt-alpha">
            <div class="rt-block logo-block">
            <%
			set rs = oCon.Execute("select CompanyLogoImage FROM GlobalSettings where clientid = "&Session("clientid") & " "  )
			If IsNull(rs("CompanyLogoImage")) OR rs.eof Then
			%>
            <a href="index.asp"> <img src="images/logo_final5.png" alt="Click for Home Page" style="height:45px;"  /></a>
            
            <% ELSE %>
            <a href="index.asp"><img src="img/<%=session("complogo")%>" alt="Click for Home Page" style="height:45px;"  /></a>
            
            <% END IF %>
        </div>
        
</div>
<br><br><br>




    	<div class="rt-block menu-block">
        
		<div class="gf-menu-device-container"></div>
<ul class="gf-menu rt-desktop-menu l1 " >
                    <li class="item108" >

            <a class="item icon" href="index.asp"  >

                                <span class="icon-home"></span><span class="menu-text">Home</span>            </a>


            
                                   
                                    </li>
                                    
                    <% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"2")) OR (instr(Session("UserTypes"),"7")) THEN %>                 
             <li class="item117 active last" >

            <a class="item icon" href="javascript:void(0);"  >

                                <span class="icon-quote-right"></span><span class="menu-text">Bids</span>            </a>
  <div class="dropdown columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l2">
                              <% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) THEN %>                                                                                          <li class="item1090" >

            <a class="item" href="search_customer.asp"  >
<span class="icon-search"></span><span class="menu-text"> Search Customers</span>
                                           </a>


                    </li>
                                                                             
                                                                             
<li class="item2090" >

            <a class="item" href="add_job.asp"  >
<span class="icon-calendar"></span><span class="menu-text"> Schedule Bids</span>
                                           </a>


                    </li>                                                                                                                        <li class="item1100" >

            <a class="item" href="leads_manager.asp"  >
<span class="icon-phone"></span><span class="menu-text"> Manage Leads</span>
                                           </a>

                    </li>
                          <% END IF %>  
                          
                           <% IF checkIT2(Session("UserTypes"),"2","1") AND checkIT2(Session("UserTypes"),"2","7") THEN %>
                            <li class="item1090" >

            <a class="item" href="search_customer2.asp"  >
<span class="icon-search"></span><span class="menu-text"> Search Customers</span>
                                           </a>


                    </li>
                           <li class="item2090" >

            <a class="item" href="add_job2.asp"  >
<span class="icon-calendar"></span><span class="menu-text"> Schedule Bids</span>
                                           </a>


                    </li>
                           
                           <% END IF %>
                                                    <% IF (instr(Session("UserTypes"),"2"))  THEN %>                                                       
                      
                    <li class="item2100" >

            <a class="item" href="estimate_manager_created_estimator.asp"  >
<span class="icon-wrench"></span><span class="menu-text"> Manage My Bids</span>
                                           </a>

                    </li>
<% end if%>                            
                                                                                                        </ul>
                        </div>
                                            </div>


            </li>
            
            <% END IF %>
                          
                          
 <% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"3")) OR (instr(Session("UserTypes"),"7")) OR (instr(Session("UserTypes"),"8")) THEN %>          
                 <li class="item117" >

            <a class="item icon" href="javascript:void(0);"  >

                                <span class="icon-truck"></span><span class="menu-text">Jobs</span>            </a>
  <div class="dropdown columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l2">
                              
                    

          <% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) OR (instr(Session("UserTypes"),"8")) THEN %>                                             <li class="item4090" >

            <a class="item" href="production_board.asp"  >
<span class="icon-coffee"></span><span class="menu-text"> Production Board</span>
                                           </a>


                    </li>                                                                     <li class="item21034" >

            <a class="item" href="acceptance_manager.asp"  >
<span class="icon-wrench"></span><span class="menu-text"> Manage All Jobs</span>
                                           </a>

                    </li>
                    
                   <% END IF %>    
                        
                         <% IF (instr(Session("UserTypes"),"3")) THEN %>
            <li class="item122 " >

            <a class="item icon" href="job_manager.asp"  >

                                <span class="icon-clock"></span><span class="menu-text">View My Jobs</span>            </a>


            </li>
                      <% End IF %>    
                  <li class="item3092" >

           <a class="item" href="javascript:void(0);" onClick="MM_openBrWindow('power_washer_calendar.asp','PWCalendar','width=300,height=700')"><span class="icon-table"></span><span class="menu-text"> Preworker Calendar</a></span>

                    </li>
                    <li class="item3093" >

           <a class="item" href="javascript:void(0);" onClick="MM_openBrWindow('paint_crew_calendar.asp','JCCalendar','width=300,height=700')"><span class="icon-calendar"></span><span class="menu-text"> Job Crew Calendar</a></span>


                    </li>
                    <li class="item4096" >

            <a class="item" href="index_complaints.asp"  >
<span class="icon-lemon"></span><span class="menu-text"> Complaints</span>
                                           </a>



                    </li>
                     <% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) THEN %>
                    <li class="item4097" >

            <a class="item" href="jobs_to_invoice.asp"  >
<span class="icon-tasks"></span><span class="menu-text"> Invoice</span>
                                           </a>


                    </li>
                     <li class="item4098" >

            <a class="item" href="payouts.asp"  >
<span class="icon-bell-alt"></span><span class="menu-text"> Payouts</span>
                                           </a>


                    </li>
                    <% END IF %>                                                                               </ul>
                        </div>
                                            </div>

                    </li>
            <%
			END IF
			%>
             <% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) THEN %>
                     
              <li class="item118 " >

            <a class="item icon" href="javascript:void(0);"  >

                                <span class="icon-bar-chart"></span><span class="menu-text">Reports</span>            </a>

 <div class="dropdown columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l2">
                                     <li class="item3090" >

            <a class="item" href="index_leads.asp"  >
<span class="icon-lightning"></span><span class="menu-text"> Leads Board</span>
                                           </a>


                    </li> <li class="item3090432" > <a class="item" href="profit_by_estimator.asp"  > <span class="icon-trophy"></span><span class="menu-text"> Profit Board</span></a></li>  
                                      <li class="item803090 parent">
                                      <a class="item" href="javascript:void(0);"  >
<span class="icon-paper-clip"></span><span class="menu-text"> Sales</span>
                                           </a>
                                        <div class="dropdown flyout columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l3">
                                                                                                                
                    <li class="item3091" >

            <a class="item" href="index_sales.asp"  >
<span class="icon-inbox"></span><span class="menu-text"> Weekly Sales</span>
                                           </a>


                    </li>
                    <li class="item3092" >

            <a class="item" href="index_yoy.asp"  >
<span class="icon-repeat"></span><span class="menu-text"> Year Over Year</span>
                                           </a>


                    </li>
                    
                     <li class="item223092" >

            <a class="item" href="rev_month.asp"  >
<span class="icon-calendar"></span><span class="menu-text"> Revenue/Month</span>
                                           </a>


                    </li>
                    
                     <li class="item333092" >

            <a class="item" href="rev_job.asp"  >
<span class="icon-wrench"></span><span class="menu-text"> Revenue/Job</span>
                                           </a>


                    </li>
                    <li class="item343092" >
            <a class="item" href="rev_estimator.asp"  >
<span class="icon-chart"></span><span class="menu-text"> Revenue/Est</span>
                                           </a>
                    </li>                     <li class="item353092" >
            <a class="item" href="rev_crew.asp"  >
<span class="icon-user"></span><span class="menu-text"> Revenue/Crew</span>
                                           </a>
                    </li>
                     <li class="item333092" >
            <a class="item" href="chart4.asp"  >
<span class="icon-cancel"></span><span class="menu-text"> Rejections</span>
                                           </a>
                    </li>      
                                                                              </ul>
                        </div>
                                            </div>

                                      </li>
                                      <li class="item12349 parent" >

            <a class="item" href="javascript:void(0);"  >

                                <span class="icon-paste"></span><span class="menu-text"> Production</span>            </a>
                                           <div class="dropdown flyout columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l3">
                                                                                                                
                    <li class="item143091" >
            <a class="item" href="index_clients.asp"  >
<span class="icon-inbox"></span><span class="menu-text"> Active Customers</span>
            </a>
                    </li>
                    
                     <li class="item153091" >
            <a class="item" href="customer_satisfaction.asp"  >
<span class="icon-thumbs-up"></span><span class="menu-text"> Customer Sat</span>
            </a>
                    </li>
                    
                     <li class="item163091" >
            <a class="item" href="Weekly_Profit.asp"  >
<span class="icon-cog"></span><span class="menu-text"> Foreman Weekly</span>
            </a>
                    </li>
                    
                     <li class="item173091" >
            <a class="item" href="Weekly_WageHours.asp"  >
<span class="icon-money"></span><span class="menu-text"> Wages Weekly</span>
            </a>
                    </li>
                                </ul>
                                </li>
                                                                                
                    <li class="item3093 parent" >

            <a class="item" href="javascript:void(0);"  >
<span class="icon-plus"></span><span class="menu-text"> Profit</span>
                                           </a>
  <div class="dropdown flyout columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l3">
                                                                                                             
                   <li class="item4423092" >

            <a class="item" href="profit_month.asp"  >
<span class="icon-calendar"></span><span class="menu-text"> Profit/Month</span>
                                           </a>


                    </li>
                    
                     <li class="item4433092" >

            <a class="item" href="profit_job.asp"  >
<span class="icon-wrench"></span><span class="menu-text"> Profit/Job</span>
                                           </a>


                    </li>
                    <li class="item4443092" >
            <a class="item" href="profit_estimator.asp"  >
<span class="icon-chart"></span><span class="menu-text"> Profit/Est</span>
                                           </a>
                    </li>                    
                     <li class="item44334092" >
            <a class="item" href="marketing_breakdown.asp"  >
<span class="icon-bullhorn"></span><span class="menu-text"> Marketing ROI</span>
                                           </a>
                    </li>   
</ul>
                    </li>
                    </ul></div></div>
                    
            </li>
            <% END IF %>
            
            
            
            
            
             <% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) OR (instr(Session("UserTypes"),"8")) THEN %>
                    
                   
          
 <div class="dropdown columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l2">
                                                                                                                    
                    

            <a class="item" href="index_clients.asp"  >
<span class="icon-group"></span><span class="menu-text"> Active Customers</span>
                                           </a>


                    </li>
                    
                      <li class="item4095" >

            <a class="item" href="customer_satisfaction.asp"  >
<span class="icon-check"></span><span class="menu-text"> Customer Sat</span>
                                           </a>


                    </li>
                     
                    </ul></div></div>
                    
                    

            </li>
            <%
			END IF
			%>
                   
                   
                   
                   
                   <%if session("InternalMessagingYesNo") = True then%>
                <li class="item120"  >

            <a class="item icon" href="javascript:void(0);"  >

                                <span class="icon-comments"></span><span class="menu-text">Messages</span>            </a>

<div class="dropdown columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l2">
                <%
		  'get counts

					  	flash = "false"
			set inbox = oCon.execute("SELECT count(*) as inboxcount FROM EmployeeMessages WHERE clientid = "&Session("clientid")&" and recipientid = "& Session("UserID") &" and Archived=0 ")
			inboxcount = inbox("inboxcount")
			inbox.close
			if inboxcount = 0 then
				set inbox = oCon.execute("SELECT count(*) as inboxcount FROM EmployeeMessages WHERE clientid = "&Session("clientid")&" and recipientid = "& Session("UserID") &" and Archived=0 and mustreply=1 and (messagestatus = 'Read' OR messagestatus = 'Unread') ")
				inboxcount = inbox("inboxcount")
				if cint(inboxcount) > 0 then
					flash = "true"
				end if
				inbox.close
			end if
			set inbox = oCon.execute("SELECT count(*) as inboxcount FROM EmployeeMessages WHERE clientid = "&Session("clientid")&" and recipientid = "& Session("UserID") &" and Archived=0 and mustreply=1 and (messagestatus = 'Read' OR messagestatus = 'Unread') ")
				rinboxcount = inbox("inboxcount")
				if cint(rinboxcount) > 0 then
					flash = "true"
				end if
				inbox.close	
			'if flash = "false"
				set inbox = oCon.execute("SELECT count(*) as inboxcount FROM EmployeeMessages WHERE clientid = "&Session("clientid")&" and recipientid = "& Session("UserID") &" and messagestatus = 'Unread' ")
				rinboxcount = inbox("inboxcount")
				if cint(rinboxcount) > 0 then
					flash = "true"
				end if
				inbox.close		
			'end if
			set inbox = nothing
			set sentbox = oCon.execute("SELECT count(*) as sentboxcount FROM EmployeeMessages WHERE clientid = "&Session("clientid")&" and Archived=0 and senderid = "& Session("UserID") &" ")
			sentboxcount = sentbox("sentboxcount")
			sentbox.close
			set sentbox = nothing
			oCon.execute("update employeemessages set Archived=1 WHERE (((employeemessages.[senderid])="& Session("UserID") &") AND ((employeemessages.[messagestatus])='Read' Or (employeemessages.[messagestatus])='Replied') AND ((DateDiff(DAY, messagedate, GETDATE())>10 )))") 
			
			if flash = "true" then
				%>
                <li class="item4090" >

            <a id="flashtext" class="item" href="user_message.asp"  >
<span class="icon-th-list"></span><span class="menu-text"> Open Messages&nbsp;(<%=inboxcount%>)</span>
                                           </a>


                    </li>
				
				<%
			else
				%>
                  <li class="item4090" >

            <a class="item" href="user_message.asp"  >
<span class="icon-th-list"></span><span class="menu-text"> Open Messages&nbsp;(<%=inboxcount%>)</span>
                                           </a>


                    </li>
               
				<%	
			end if
		  %>
          
            <li class="item4100" >

            <a class="item" href="sent_message.asp"  >
<span class="icon-arrow-up"></span><span class="menu-text"> Sent Messages&nbsp;(<%=sentboxcount%>)</span>
                                           </a>

                    </li>
          
          <li class="item41300" >

            <a class="item" href="user_message_archived.asp"  >
<span class="icon-minus-sign"></span><span class="menu-text"> Archived Messages</span>
                                           </a>

                    </li>
          	<li class="item4100" >

            <a class="item" href="send_message.asp"  >
<span class="icon-envelope-alt"></span><span class="menu-text"> Send New Message</span>
                                           </a>

                </li>   </ul>
                        </div>
                                            </div>
            </li>
           
    <%end if%>        
                   
                   
                   
                   
                   
                   
                   
                   
          <% IF (instr(Session("UserTypes"),"1")) OR (instr(Session("UserTypes"),"7")) THEN %>         
                              
                    <li class="item121" >

            <a class="item icon" href="javascript:void(0);"  >

                                <span class="icon-cogs"></span><span class="menu-text">Settings</span>            </a>

 <div class="dropdown columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="5l2">
                                                                                                                    <li class="item5090" >

            <a class="item" href="global_configuration.asp"  >
<span class="icon-globe"></span><span class="menu-text"> Main Settings</span>
                                           </a>


                    </li>
                     <li class="item5491" >

            <a class="item" href="emailmsg_manage.asp"  >
<span class="icon-envelope-alt"></span><span class="menu-text"> Customer Emails</span>
                                           </a>
                    </li>
                    
                     <li class="item773093 parent" >

            <a class="item" href="javascript:void(0);"  >
<span class="icon-plus"></span><span class="menu-text"> User Settings</span>
                                           </a>
  <div class="dropdown flyout columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l3">
                    
                    <li class="item5091" >

            <a class="item" href="user_manager.asp"  >
<span class="icon-group"></span><span class="menu-text"> User Manager</span>
                                           </a>
                    </li>
                    <li class="item5991" >

            <a class="item" href="estimator_order.asp"  >
<span class="icon-sort"></span><span class="menu-text"> Estimator Order</span>
                                           </a>
                    </li>
                    <li class="item5891" >

            <a class="item" href="message_manager.asp"  >
<span class="icon-comment"></span><span class="menu-text"> Message Manager</span>
                                           </a>
                    </li>
                    </ul></div></div>
                    <li class="item883093 parent" >

            <a class="item" href="javascript:void(0);"  >
<span class="icon-plus"></span><span class="menu-text"> Job Settings</span>
                                           </a>
  <div class="dropdown flyout columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l3">
                    <li class="item5191" >

            <a class="item" href="estimate_types_manager.asp"  >
<span class="icon-briefcase"></span><span class="menu-text"> Job Types</span>
                                           </a>
                    </li>
                   <li class="item5591" >

            <a class="item" href="cancellation_reason_manager.asp"  >
<span class="icon-cancel"></span><span class="menu-text"> Est Cancel Types</span>
                                           </a>
                    </li><li class="item5691" >

            <a class="item" href="job_cancellation_reason_manager.asp"  >
<span class="icon-thumbs-down"></span><span class="menu-text"> Job Cancel Types</span>
                                           </a>
                    </li>
                    
                    <li class="item5391" >

            <a class="item" href="dead_reasons_manager.asp"  >
<span class="icon-minus"></span><span class="menu-text"> Rejection Types</span>
                                           </a>
                    </li><li class="item5791" >

            <a class="item" href="complaint_manager.asp"  >
<span class="icon-lemon"></span><span class="menu-text"> Problem Types</span></a></li>
                    <%if session("DetailedMaterialsYesNo") = True then%>
                    <li class="item3215791" > <a class="item" href="material_category_manager.asp"  > <span class="icon-tag"></span><span class="menu-text"> Manage Materials</span></a></li>
                    <% end if %>
                    </ul></div></div>
                     <li class="item993093 parent" >

            <a class="item" href="javascript:void(0);"  >
<span class="icon-plus"></span><span class="menu-text"> Marketing Settings</span>
                                           </a>
  <div class="dropdown flyout columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l3">
                    <li class="item5291" >

            <a class="item" href="referral_types_manager.asp"  >
<span class="icon-bullhorn"></span><span class="menu-text"> Referral Types</span>
                                           </a>
                    </li><li class="item5391" >

            <a class="item" href="referral_spend_manager.asp"  >
<span class="icon-list"></span><span class="menu-text"> Marketing Costs</span>
                                           </a>
                    </li>
                    </ul></div></div>
                     <li class="item9883093 parent" >

            <a class="item" href="javascript:void(0);"  >
<span class="icon-plus"></span><span class="menu-text"> Data Export</span>
                                           </a>
  <div class="dropdown flyout columns-1 " style="width:180px;">
                                                <div class="column col1"  style="width:180px;">
                            <ul class="l3">
                    <li class="item1100" >

            <a class="item" href="customers_export.asp"  >
<span class="icon-cloud-download"></span><span class="menu-text"> Export Customers</span>
                                           </a>

                    </li>       
                                    
                              <li class="item12100" >

            <a class="item" href="jobs_export.asp"  >
<span class="icon-cloud-download"></span><span class="menu-text"> Export Jobs</span>
                                           </a>

                    </li>
                                     
                    </ul></div></div>
                    </ul></div></div>
                    </li>
                 <% END IF %>   
                    
                 
                      
                       <% IF checkIT2(Session("UserTypes"),"2","7") or checkIT2(Session("UserTypes"),"3","7") or checkIT2(Session("UserTypes"),"4","7") or checkIT2(Session("UserTypes"),"5","7") or checkIT2(Session("UserTypes"),"6","7") or checkIT2(Session("UserTypes"),"8","7") THEN %>
           
            <li class="item1223 " >

            <a class="item icon" href="my_profile.asp"  >

                                <span class="icon-pencil"></span><span class="menu-text">My Profile</span>            </a>


            </li>
            <%
			END IF
			%>
                   
                   
            <li class="item124" >

            <a class="item icon" href="login_redirect.asp"  >

                                <span class="icon-signout"></span><span class="menu-text">Logout</span>            </a>


            </li>
            
            </ul>		<div class="clear"></div>
	
	
</div>
					<div class="clear"></div>
				</div>
			</div>
					</header>
						<div id="rt-transition">
			<div id="rt-mainbody-surround">
																												<div class="rt-container">
					          
<div id="rt-main" class="mb12">
                <div class="rt-container">
                    <div class="rt-grid-12 ">
                                                					

<div id="rt-mainbody">
      <h2>Locate an Existing Customer</h2>
      <form id="CustomerSearch" name="CustomerSearch" method="post" action="customer_results.asp">
        <h2>&nbsp;</h2>
        <table width="60%" border="0">
          <tr>
            <td><h4>Phone Number </h4></td>
            <td><input type="text" name="PhoneNumber" id="PhoneNumber" />
            </td>
          </tr>
          <tr>
            <td><h4>Name</h4></td>
            <td><input type="text" name="CustomerName" id="CustomerName" />
           </td>
          </tr>
          <tr>
            <td><h4>Street</h4></td>
            <td><input type="text" name="Street" id="Street" /></td>
          </tr>
          <tr>
            <td><h4>Comments</h4></td>
            <td><input type="text" name="Comments" id="Comments" /></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><input type="submit" name="Search" id="Search" value="Search" class="button" /></td>
          </tr>
        </table>
        <table cellpadding="2" cellspacing="0" border="0">
          <tr>
            <td align="center"><input type="hidden" name="WADbSearch1" value="Submit" /></td>
          </tr>
        </table>
      </form>
      <p>&nbsp;</p>
      <h1><br />
      </h1>
<div class="clear"></div>

	</div>

    <br class="clearFloat" />
                                                                    </div>
                                        <div class="clear"></div>
                </div>
            </div>
				</div>
															</div>
		</div>
						<footer id="rt-footer-surround">
						<div id="rt-footer">
				<div class="rt-container">
					<div class="rt-grid-8 rt-alpha">
               <div class="rt-block box5 fp-footer-a">
           	<div class="module-surround">
	           		                	<div class="module-content">
	                		

<div class="custombox5 fp-footer-a"  >
	<div class="rt-footer-logo" style="height:35px;" > 
	</div>
</div>
	                	</div>
                	</div>
           </div>
	
</div>
<div class="rt-grid-4 rt-omega">
               <div class="rt-block fp-footer-b">
           	<div class="module-surround">
	           		                	<div class="module-content">
	                		

<div class="custombox5 fp-footer-b"  >
	<br>
<a href="javascript:void(0);" ><i class="icon-question-sign icon-help-huge" onClick="MM_openBrWindow('/instructions/homepage.html','homepage','scrollbars=yes,resizable=yes,width=600,height=400')"></i></a>



</div>
	                	</div>
                	</div>
           </div>
	
</div>
					<div class="clear"></div>
				</div>
			</div>
									<div id="rt-copyright">
				<div class="rt-container">
					<div class="rt-grid-3 rt-alpha">
    	<div class="clear"></div>
				  </div>
<div class="rt-grid-7">
               <div class="rt-block horizmenu rt-center hidden-phone">
           	<div class="module-surround">
	           		                	<div class="module-content">
	                		<ul class="nav menu">
<li class="item-134"></li></ul>
	                	</div>
               	 </div>
           </div>
	
</div>
<div class="rt-grid-2 rt-omega">
    	<div class="clear"></div>
</div>
					<div class="clear"></div>
				</div>
				
                          </div>
					</footer>
									</div>
</body>
</html>
<%
User.Close()
Set User = Nothing
%>
<%
summary.Close()
Set summary = Nothing
%>

Open in new window



 The mande2 connection file is used on all other pages and works great.

The authentication check also appears on every other page of the site, and doesn't kick us on other pages.

Any suggestions would be great. I'm OK with chasing down error messages, but inexplicable session state behavior is pretty confounding.

Thanks

Bill
0
Comment
Question by:billium99
  • 2
4 Comments
 
LVL 1

Author Comment

by:billium99
ID: 40599164
Another clue: wandering around the application, there do seem to be other times it's logging us out. The moment it happens, it appears MS SQL service is restarted. But there are no logs indicating why it restarted.
0
 
LVL 76

Accepted Solution

by:
arnold earned 250 total points
ID: 40600202
your user credential are stored as a session, check if the sql service is set for auto-recovery. do you have monitoring of the service that has a way to trigger a restart?
check schtasks.
use perfmon to monitor sql instance memory use to see whether it is

if IIS monitor its memory
SQL being restarted or IIS?
0
 
LVL 52

Assisted Solution

by:Scott Fell, EE MVE
Scott Fell,  EE MVE earned 250 total points
ID: 40601332
It could be possible your worker process associated with the application pool is failing and thus resetting the session.

Take out your dreamweaver generated auth code and run the page.  If you have access to the server, look to see if the memory/cpu is maxing out.  

Did you edit any code out?  It looks like on line 55 above you would expect a closing asp tag and then an opening asp tag since you are generating this via dreamweaver.  This page would still work as is, but your dreamweaver functions may not.

Beyond that, maybe the real issue is customer_results.asp since that is where the form is posting to.
0
 
LVL 1

Author Closing Comment

by:billium99
ID: 40604926
Still not resolved but much more narrowed down - thanks
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now