ASP.NET long queries

R

rescobar

Member
Joined
May 21, 2003
Messages
7
Location
La Paz
Im trying to run an ASP.NET app using VS.NET 2002 in a Windows 2003 Server. This application run ok under Windows 2000 with VS.NET 2000.
One of my processes runs a package in a SQL Server. This process takes more than 5 minutes. At aprox. 5 minutes I obtain the follwing message in the browser:

The page cannot be displayed
..... blah
..... blah
......

Cannot find server or DNS Error
Internet Explorer

I tried to move every "timeout" variable in machine.config without results.
Does anyone knows what to do?
Thanks in advance
Ramiro
 
Where do I have to configure the package as stateless/asynchronous? In the SQL Server? in the asp application?. I spent two days until now. Thanks for your kind help
 
The threading is done using ASP....

[mshelp]ms-help://MS.VSCC/MS.MSDNVS/cpref/html/frlrfSystemThreadingThreadClassStartTopic.htm[/mshelp]
 
My code follows. It works, but in the redirect statament
the "The resource cannot be found. HTTP 404" error is produced.

Dim ePaq As New clsPersistencia
Dim bThreadStart As New ThreadStart(AddressOf ePaq.EjecutaPaquetesClmst1_01)
Dim bThread As New Thread(bThreadStart)
bThread.Start()
Dim ii As Integer
Do While bThread.ThreadState = System.Threading.ThreadState.Running
ii += 1
Loop
Response.Redirect("Principal.aspx")

Do you have any idea?
Tks and rgds
 
In case you perfer to let the thread run on its own, you can get rid of the following...
Code: 
Dim ii As Integer
Do While bThread.ThreadState = System.Threading.ThreadState.Running
ii += 1
Loop
 
The last thing that I woul want to do before the new thread ends is request.redirect an asp page to warn the user that the long thread is finished. any idea? Tks again
 
Sorry, I got out the loop from the code. My new code is as follows:
Dim ePaq As New clsPersistencia
Me.lblDateTime.Text = Date.Now.TimeOfDay.ToString
ePaq.strArg = ePaq.ProcesoThread.Calificacion.sPttit1_01
Dim bThreadStart As New ThreadStart(AddressOf ePaq.EjecutaPaquete)
Dim bThread As New Thread(bThreadStart)

bThread.Start()
Response.Redirect("Espere.aspx"

When the code includes a loop, there is a timeout
 
Back
Top