Larry Brister
asked on
Browser Timeout
Have a .Net web with the code below which returns a simple number which I can add to a string.
The execution time on the code is about 10 seconds to get a number back from the server....very complex select on the other end.
Here's the deal...
I can run this fine in Google Chrome, Safari, and Mozilla...
But IE bombs out with an Execution Timeout message.
Current (our office platforms) is WInXP and IE8
This is the vb that gets the data back
The execution time on the code is about 10 seconds to get a number back from the server....very complex select on the other end.
Here's the deal...
I can run this fine in Google Chrome, Safari, and Mozilla...
But IE bombs out with an Execution Timeout message.
Current (our office platforms) is WInXP and IE8
This is the vb that gets the data back
Private Function getEmailBlastCount(ByVal st As String, ByVal specialty As String, ByVal ckFederal As Boolean) As String
Dim objConn As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("ConnStr"))
Dim oCom As New SqlCommand
oCom.Connection = objConn
oCom.CommandText = "usp_EmailsForSpecialtyStatesGetCount"
oCom.CommandType = CommandType.StoredProcedure
oCom.Parameters.Add(New SqlParameter("@State", SqlDbType.VarChar, 2)).Value = st
oCom.Parameters.Add(New SqlParameter("@Specialty", SqlDbType.VarChar, 50)).Value = specialty
oCom.Parameters.Add(New SqlParameter("@Nationwide", SqlDbType.Bit)).Value = ckFederal
objConn.Open()
Dim dR As SqlDataReader
dR = oCom.ExecuteReader()
dR.Read()
If dR.HasRows Then
Return "There are " & dR("emailBlastCount") & " emails in this blast"
Else
Return "There are <strong><u>NO</u></strong> emails in this blast"
End If
dR.Close()
objConn.Close()
objConn.Dispose()
objConn = Nothing
oCom = Nothing
End Function
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
These were commented out for some reason...
<httpRuntime maxRequestLength="8192" executionTimeout="3600"/>
<sessionState timeout="180"/>