Having a timeout problem

T

tfs

I have a page that is running a DTS package and takes anywhere from 1
minute to 20 minutes. When it comes back it displays in my textbox
the results.

The problem is that on the long packages, the page times out after
about 30 seconds.

What is the best way to display a now processing ticker and prevent
the page from timing out?

Here is a snippet of the code I am running:

Dim objConnect as SqlConnection = new
SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_Contour_Server"))

objConnect.Open()

sqlString = "exec master.dbo.xp_cmdshell 'dtsrun /S " &
chr(34) & "OPENWORX" & chr(34)
& " /N " & chr(34) &
request.QueryString("name") & chr(34)
& " /E '"

Dim objCommand as SqlCommand = new SqlCommand(sqlString,
objConnect)
Dim objDataReader as SqlDataReader = objCommand.ExecuteReader( _
CommandBehavior.CloseConnection)

dim ktr as integer
ktr = 0
while (objDataReader.Read() = true)
if(objDataReader(0) is System.DBNull.value) then
sResults = ""
else
sResults = objDataReader(0)
end if

results.text = results.text & sResults & vbCrLf
ktr = ktr + 1
end while

results.text = results.text & "at end of loop ktr = "
& ktr & vbCrLf
objDataReader.Close()
objCommand.Dispose()
objConnect.Close()


The code sits at the ExecuteReader until the DTS Package is done.

Thanks,

Tom.
 
B

Bobby Ryzhy

The DTS package needs to be started from an assyncronous process. One that starts it and returns to the page an immediate result. The page
then need to poll the process for progress (basically refreshing itself every 5 seconds or so).

Bobby Ryzhy
bobby@ domain below
http://weekendtech.net


I have a page that is running a DTS package and takes anywhere from 1
minute to 20 minutes. When it comes back it displays in my textbox
the results.

The problem is that on the long packages, the page times out after
about 30 seconds.

What is the best way to display a now processing ticker and prevent
the page from timing out?

Here is a snippet of the code I am running:

Dim objConnect as SqlConnection = new
SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_Contour_Server"))

objConnect.Open()

sqlString = "exec master.dbo.xp_cmdshell 'dtsrun /S " &
chr(34) & "OPENWORX" & chr(34)
& " /N " & chr(34) &
request.QueryString("name") & chr(34)
& " /E '"

Dim objCommand as SqlCommand = new SqlCommand(sqlString,
objConnect)
Dim objDataReader as SqlDataReader = objCommand.ExecuteReader( _
CommandBehavior.CloseConnection)

dim ktr as integer
ktr = 0
while (objDataReader.Read() = true)
if(objDataReader(0) is System.DBNull.value) then
sResults = ""
else
sResults = objDataReader(0)
end if

results.text = results.text & sResults & vbCrLf
ktr = ktr + 1
end while

results.text = results.text & "at end of loop ktr = "
& ktr & vbCrLf
objDataReader.Close()
objCommand.Dispose()
objConnect.Close()


The code sits at the ExecuteReader until the DTS Package is done.

Thanks,

Tom.

Bobby Ryzhy
bobby @ domain below
http://weekendtech.net
 
B

Bobby Ryzhy

go to groups.google.com and type in asyncronous webservice.

Bobby Ryzhy
bobby@ domain below
http://weekendtech.net

Bobby Ryzhy said:
The DTS package needs to be started from an assyncronous process. One
that starts it and returns to the page an immediate result. The page
then need to poll the process for progress (basically refreshing itself
every 5 seconds or so).

How would I do that? I assume that is not what I am doing now?

Tom.

Bobby Ryzhy
bobby@ domain below
http://weekendtech.net

Bobby Ryzhy
bobby @ domain below
http://weekendtech.net
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top