AHHH just launched a website and now getting HTTP 500!

[Alphathree33]

I just uploaded a website and e-mailed like 50 people saying "go look!"

And now I'm getitng an HTTP 500 error.

I'm using ASP/VBSCRIPT... I can't figure it out. The website works for five minutes and then all of the sudden, every single page posts an HTTP 500. What could be wrong?

I have a hunch that not closing connection objects could be doing this -- i.e. not saying

Conn.close
Set Conn = Nothing

... Should I try that? (So many pages!)

Argh!

 

[Alphathree33]

Also, I use Application.Lock and Application.UnLock... could that cause an HTTP 500 if, say, it were locked and then not unlocked?

 

[kt]

It's a good practice to have a include file that closes all your database connection, etc. That way you only need to make edits to one file.

 

[Alphathree33]

Originally posted by: kt
It's a good practice to have a include file that closes all your database connection, etc. That way you only need to make edits to one file.

I'm using an include with Connect() and Disconnect() defined, and I call them on every page.

Anyway, I don't think that's it anymore... I think what was hapenning is I was calling Application.Lock, doing a SQL operation that failed, and thus never getting to Application.UnLock... at least, I hope that's what it was. It's working again now. *crosses fingers*

 

[Alphathree33]

ARGH it's doing it again!!

 

[chsh1ca]

Without seeing your whole script there's really no way to reliably guess. It's like shooting at a guy dressed in all black in a room with no windows and no lights.

 

[Gaunt]

This is just a guess, but I've had something similar to this happen before.

What operating system is your web site running under? Windows 2000 Professional IIS will only support 10 connections to the web server at one time. You can reach this limitation if you quickly refresh the page many times (Hold down refresh hotkey in your browser). Using Windows 2000 Server will get rid of this limitation.

 

[Barnaby W. Füi]

Check your logs.