| Author |
 Topic Search  Topic Options
|
ub3rl337ch3ch 
Senior Member
Joined: 16 February 2005
Location: Australia
Status: Offline
Points: 341
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 05 September 2005 at 9:53pm |
*note to self*
must remember to do that... 
perhaps a dumb question, but what exactly does leaving the connections hanging actually do? i know its bad, but not why... 
|
 |
padoxky
Groupie
Joined: 17 June 2004
Location: Nigeria
Status: Offline
Points: 78
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 September 2005 at 5:46am |
Thanks buddies,
I have found the error. Is from my database tbls, the strConfirm = RandomPW(0) suppose to be a Text field in my database tbl but i mistakely used Number field instead of Text that is the reason the error occured.
But, is there any of my connection left hanging?
|
|
NgWebDesigns
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 September 2005 at 7:09pm |
|
Connections come from a pool and there's only so many to go around for
all the sites hosted on the server. They'll attempt to clean themselves
up after some period of inactivity but sometimes they don't release the
memory they use.
With 500 other sites on a machine all opening and closing connections
you don't have to run a script that leaves connections hanging very
many times before iis has to reset. Problem occurs more often if you're
developing online.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
ub3rl337ch3ch
Senior Member
Joined: 16 February 2005
Location: Australia
Status: Offline
Points: 341
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 September 2005 at 7:16pm |
*fixes programs*
is it just connections or recordsets (the object, i'm not quite lazy/forgetful enough to forget vrec.close) and the like as well?
also, to continue my hijacking of this thread, is there a way to close connections similar to opening them with a server side include? or can ssi's only be used at the start of a file?
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 September 2005 at 4:39am |
|
You can put an ssi anywhere. You just have to be careful with the asp open and close tags - <% and %>.
If your ssi code has them you'll have to put close %> before the ssi then open <% after the ssi.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
padoxky
Groupie
Joined: 17 June 2004
Location: Nigeria
Status: Offline
Points: 78
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 September 2005 at 5:08am |
Can you pin point the connections that is left hanging. I think i close all my connection by using this
Set rsNew = nothing.
Or they any other way of doing that?
|
|
NgWebDesigns
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 September 2005 at 5:16am |
|
your connections were ok... it would have only happened if you used response.end before closing the connections.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
padoxky
Groupie
Joined: 17 June 2004
Location: Nigeria
Status: Offline
Points: 78
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 September 2005 at 5:23am |
can you tell me the differences between
Set rsNew = nothing
and
rsNew.Close
|
|
NgWebDesigns
|
|
