asp page freezes in netscape when select data from database

[tangyi]

hi,
can anyone help me with this problem?
the asp page which displays data from my database freezes before it displays anything in netscape.
i tried to set response.buffer = false , which didn't help.
i'm thinking netscape freezes because it's waiting for data from the server to display for too long.
thanks.
tang_yi

 

[TechnicalAnalysis]

Does your page has any Java Applet?
Java Applet often freeze the browser.
Could we see your code?

Regards

http://www.technical.analysis.dingojunction.com

 

[tangyi]

no, there's absolutely no java applets.
here's the code that's causing the page to freeze in netscape.
<%

Sql_query = &quot;SELECT * FROM msgbdmain Order By PostDate DESC&quot;
Set msgs = Application(&quot;MainDBConn&quot.execute(Sql_query)
dim counter
counter = 0
While Not msgs.EOF
MsgNum = msgs(&quot;MsgNum&quot
counter = counter+1
%>
<tr>
<td width=&quot;16%&quot; align = &quot;left&quot; bgcolor=&quot;#FFFFFF&quot;>&nbsp;<font size=&quot;2&quot; class=&quot;blacktext&quot;><%=msgs(&quot;PostDate&quot%></font></td>
<td width=&quot;49%&quot; align = &quot;left&quot; bgcolor=&quot;#FFFFFF&quot;>&nbsp;<a href =&quot;viewmsg.asp?msg=<%=MsgNum%>&quot;><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;2&quot; class=&quot;blacktext&quot;><%=msgs(&quot;Subject&quot%></font></a></td>
<td width=&quot;22%&quot; align = &quot;left&quot; bgcolor=&quot;#FFFFFF&quot;>&nbsp;<a href = &quot;mailto:<%=msgs(&quot;PosterEmail&quot%>&quot;><font size=&quot;2&quot; class=&quot;blacktext&quot;><%=msgs(&quot;Poster&quot%></font></a></td>
<td width=&quot;13%&quot; align =&quot;center&quot; bgcolor=&quot;#FFFFFF&quot;><a href =&quot;viewmsg.asp?msg=<% =MsgNum%>#replies&quot; class=&quot;blacktext&quot;><%=msgs(&quot;ReplyNum&quot%></a></td>
</tr>

<%
if counter MOD 5 = 0 then
response.flush
end if
msgs.MoveNext
Wend
Set msgs = nothing
Set Sql_query = nothing
%>


and i have <%response.buffer=true%> at the head of the page.
i added <%response.buffer=true%> and the <%response.flush%> clause to try to fix the problem, which didn't work.
the page still freezes without the above 2 segments.
if you have netscape and don't mind to get freezed, go to

http://yitang.brinkster.net/msgbd

and see it for yourself.
(the page will eventually load)

 

[vasah20]

If your page is only freezing in netscape, it's a problem with the client side code. From this snippet, nothing looks wrong with the client side code... if you have any javascript or anything on the page, check that (I once wrote Javascript that crashed Netscape... it was my finest hour )

This is a little off topic, but the only thing I would recommend is that you _do_not_ store your connections as application level objects. You don't get to benefit from Connection pooling, and although it makes your life easier now, your application doesn't up well at all. For a more thorough discussion of this:

http://www.learnasp.com/learn/nodbsession.asp

as for the NN bug... again - check your client side code...

hth
leo

 

[tangyi]

i don't think it's the problem with the javascripts.
i took all the javascripts out, and it still freezes when loading in netscape (before anything shows up in the browser). vasah20, thank you for the db connection suggestion though.

 

[lobstah]

are your styles in a separate .css file, or are they defined in this same file? stylesheet problems could cause erratic netscape behavior.......

 

[tangyi]

i'm pretty sure it's not the css ...
anywayz, the style sheet is defined in that page
thanks for helping

 

[tangyi]

somebody help!