Entry

Using PWS on a NT 4.0 workstation, sometimes it works but, if I have bad SQL, pages stop loading and I have to reboot. What's going on?

Mar 20th, 2002 10:32
Nathan Clute, unknown unknown, Raul Villaronga

Try the following to insure it's nothing in the global.asa syntax:

Reboot and start the PWS service. Open a page that has ASP code but does
not have SQL. The global.asa will fire since it is the first ASP page
loaded. If it locks up then it's not the bad SQL. I would next remove
the global.asa file, reboot and restart the PWS service. Load the ASP
page again and see what happens. If it still locks then it may be
something in the install.

Nathan: You probably have an infinite loop somewhere. Check to see if 
you have any "While Not RS.EOF . . . Wend" statements or other while or 
for statements that have no means of exiting the loop.  Comment out 
loops and other questionable sections until you are certain each code 
segment works properly on its own and gradually integrate the parts 
together.