Having a timeout problem

[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.ConfigurationSe ttings.AppSettings("MM_CONNECTION_STRING_Contour_S erver"))

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]

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
On 12 Jul 2004 18:03:29 -0500, tf*@dslextreme-dot-com.no-spam.invalid (tfs) wrote:

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.ConfigurationS ettings.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

[Thomas Scheiderich]

"Bobby Ryzhy" <bo***@weekendtech.net> wrote in message
news:rq********************************@4ax.com...

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
On 12 Jul 2004 18:03:29 -0500, tf*@dslextreme-dot-com.no-spam.invalid (tfs) wrote:

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.ConfigurationS ettings.AppSettings("MM_CO

NNECTION_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

[Bobby Ryzhy]

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

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

On Tue, 13 Jul 2004 16:36:07 -0700, "Thomas Scheiderich" <tf*@deltanet.com> wrote:

"Bobby Ryzhy" <bo***@weekendtech.net> wrote in message
news:rq********************************@4ax.com.. .

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
On 12 Jul 2004 18:03:29 -0500, tf*@dslextreme-dot-com.no-spam.invalid

(tfs) wrote:

>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.Configuration Settings.AppSettings("MM_CO

NNECTION_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

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