I am constantly getting the 'Script timed out' error, and would like to see
if there is any way I could modify the ASP page.
I think I did all I could to improved the performance at the database table
level, but when it comes to the ASP, the error occurs most of time.
This error happens when this ASP page has been moved to a new server.
I modified the "server.ScriptTimeout = " at the ASP and also at IIS.
The report does not retrieve the whole records, but it stops in the middle,
and giving this error message.
I am also curious whether .AbsolutePosition might be a factor? But on the
previous server, I had no problem.
Here is the part of ASP page where it retrieves a data.
strSQL = "spHWABPOOrderSelect_1 " & nAcctNum
Dim rsHBSBPOOrder : Set rsHWABPOOrder = New clsRecordSet
.ConnectionString = ConnHBS
Do While Not .EOF
if .AbsolutePosition = 0 Then
nBPO1Val = Trim(.Fields("curBPOAsIs")&"")
If Len(nBPO1Val) <> 0 Then
nBPO1Val = FormatCurrency(nBPO1Val, 0)
nTmp = nBPO1Val
dtBPO1 = Trim(.Fields("dtReceived")&"")
ElseIf .AbsolutePosition = 1 Then
nBPO2Val = Trim(.Fields("curBPOAsIs")&"")
If Len(nBPO2Val) = 0 Then
nBPO2Val = nTmp
nBPO2Val = FormatCurrency(nBPO2Val, 0)
dtBPO2 = Trim(.Fields("dtReceived")&"")
Set rsHWABPOOrder = Nothing
10. ASP 0113 error
12. ERROR"ASP 0113"
13. error 'ASP 0113'