| | |
|
|
|
ASP Error Message, ASP 0113 |
|---|
| message from NeeLyn2068 on 22 Jul 2004 |
Just want to post a quick fix to a problem we were having just in case it is
not just us.
About three weeks ago, we suddenly starting getting errors on your ASP
pages. We are using IIS 6 and Microsoft Access databases. The error message
was
"Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. You can
change this limit by..."
We checked our server settings and they were already set higher then what
Microsoft was recommending to fix the error. However, on further investigation
we found that our earliest ASP pages that were developed in Dreamweaver 3 or 4
were missing the second line of code in closing the database connections. The
old closers looked like this:
<%
Recordset1.Close()
%>
They should be
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
Once we added the second line of code to our old pages all seems well with the
world.
Hope this helps someone!
|
| Murray *TMM* replied to NeeLyn2068 on 22 Jul 2004 |
DW 3 and DW 4 did not do ASP coding, so you must have done this manually.
UltraDev was the first of the "DW" programs to write ASP code for you.
When I look back at sites I did in UD (I'm not sure which version, however),
I see that corrected code already there.
|
| Les Matthews replied to Murray *TMM* on 22 Jul 2004 |
UD did not "destroy" recordsets by settting to nothing. When I have opened
an old UD-coded ASP file in MX, there has been an icon by the recordset in
server behaviors panel indicating a problem with it. Opening the recordset
and saving, places the "Set ... = Nothing" line.
"Murray *TMM*" <forums@HAHAgreat-web-sights.com> wrote in message
news:cdopai$a4d$1@forums.macromedia.com...
|
| Murray *TMM* replied to Les Matthews on 22 Jul 2004 |
I don't follow. So you are saying that UD did not put the
Set Recordset1 = Nothing
code there? It did in my sites.
|
| D. Shane Fowlkes replied to Murray *TMM* on 22 Jul 2004 |
I think with my original version of UD4, it lacked these RS killers too.
Perhaps an Updater fixed it at some point.
|
| Murray *TMM* replied to Murray *TMM* on 22 Jul 2004 |
Frankly, I am not sure....
|
|
Archived message: ASP Error Message, ASP 0113 (Macromedia Dreamweaver Web Design)
