elminate the hanging processes

Are you doing anything to help limit the impact of abandoned processes where
the object hasn't been unloaded through your code?

Not sure if that would cause your problem but it's worth a thought.

ASP.Net performs a cleanup for such things that I don't believe ASP does.





"Simon" <webmaster@sny.ca> wrote in message
news:059f01c3472b$ca5093b0$a101280a@phx.gbl...[color=blue]
> My webhosting company cut off my website the other day
> because i had "too many hanging processes"
>
> What does this mean and what can i do to prevent this from
> happening. They gave me the following readout...
>
> X 13:02:32.954 24 844 933 Preproc headers
> 24.101.225.120 111433 ns
> 0 un GET
> http://www.sny.ca/investing/institu...uctdetails.asp?
> InvestmentProductID=12
> X 13:02:40.626 24 837 261 Authentication
> 24.101.225.120 111454 ns 0
> un GET
> http://www.sny.ca/investing/search.asp?
> t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh
> X 13:08:27.287 24 490 599 Authentication
> 24.101.225.120 112977 ns 0
> un GET
> ResellersLive (4:52:21 PM):
> http://www.sny.ca/investing/search.asp?
> t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh
> X 13:09:19.327 24 438 560 Authentication
> 24.101.225.120 113243 ns 0
> un GET
> http://www.sny.ca/investing/search.asp?
> t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh
> X 13:48:50.103 22 067 783 Authentication
> 24.101.225.120 126007 ns 0
> un GET
> http://www.sny.ca/investing/search.asp?
> t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Refresh
> X 13:49:06.738 22 051 149 Preproc headers
> 24.101.225.120 126128 ns
>
> ResellersLive (4:52:23 PM): 0 un GET
> http://www.sny.ca/X 19:50:43.529 354 357 Preproc
> headers 24.101.225.120 232810 ns 0un
> GEThttp://www.sny.ca/investing/institution_productdetails.a
> sp?InvestmentProductID=5X 19:55:04.647 93 240 Preproc
> headers 24.101.225.120 233802 ns 0un
> GEThttp://www.sny.ca/investing/institution_productdetails.a
> sp?InvestmentProductID=5X 19:55:11.318 86 569
> Authentication 24.101.225.120 233832 ns 0
> unGEThttp://www.sny.ca/investing/institution_productdetails
> .asp?InvestmentProductID=12X 19:55:54.075 43 812
> Authentication 24.101.225.120 233958 ns 0
> unGEThttp://www.sny.ca/investing/search.asp?
> t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x=31&OrderB
> yRSP.y=7
>
> I haven't a clue what all that means. My website used two
> databases that i connected through without and ODBC
> connection (i gave ADO the real path of the database file
> on every open)
>
> The typial website had about 5-10 include files and i
> always closed my rs at the end of every asp file.
>
> Throughout the site i use the CreateObject method (used on
> all of the above listed files). I do not set them to null
> at the end of hte asp file - should i?
>
> Anything else?
>
> I know in VB i can use the Unload command to unload the
> form, and i can use hte END command to end the program
> (albiet a crude way of doing so), is there anything like
> this in asp?
>
> please help!
>
> Siomn
> Join Bytes![/color]

One other thing ....are you using a detached dataset when hitting your
database? Are you using Views vs the actual tables? Is your host
complaining about Database processes or your application processes?





"joe" <contact_by_Newsgroup_only.please> wrote in message
news:OY1vV0yRDHA.2148@TK2MSFTNGP10.phx.gbl...[color=blue]
> Are you doing anything to help limit the impact of abandoned processes[/color]
where[color=blue]
> the object hasn't been unloaded through your code?
>
> Not sure if that would cause your problem but it's worth a thought.
>
> ASP.Net performs a cleanup for such things that I don't believe ASP does.
>
>
>
>
>
> "Simon" <webmaster@sny.ca> wrote in message
> news:059f01c3472b$ca5093b0$a101280a@phx.gbl...[color=green]
> > My webhosting company cut off my website the other day
> > because i had "too many hanging processes"
> >
> > What does this mean and what can i do to prevent this from
> > happening. They gave me the following readout...
> >
> > X 13:02:32.954 24 844 933 Preproc headers
> > 24.101.225.120 111433 ns
> > 0 un GET
> > http://www.sny.ca/investing/institu...uctdetails.asp?
> > InvestmentProductID=12
> > X 13:02:40.626 24 837 261 Authentication
> > 24.101.225.120 111454 ns 0
> > un GET
> > http://www.sny.ca/investing/search.asp?
> > t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh
> > X 13:08:27.287 24 490 599 Authentication
> > 24.101.225.120 112977 ns 0
> > un GET
> > ResellersLive (4:52:21 PM):
> > http://www.sny.ca/investing/search.asp?
> > t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh
> > X 13:09:19.327 24 438 560 Authentication
> > 24.101.225.120 113243 ns 0
> > un GET
> > http://www.sny.ca/investing/search.asp?
> > t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh
> > X 13:48:50.103 22 067 783 Authentication
> > 24.101.225.120 126007 ns 0
> > un GET
> > http://www.sny.ca/investing/search.asp?
> > t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Refresh
> > X 13:49:06.738 22 051 149 Preproc headers
> > 24.101.225.120 126128 ns
> >
> > ResellersLive (4:52:23 PM): 0 un GET
> > http://www.sny.ca/X 19:50:43.529 354 357 Preproc
> > headers 24.101.225.120 232810 ns 0un
> > GEThttp://www.sny.ca/investing/institution_productdetails.a
> > sp?InvestmentProductID=5X 19:55:04.647 93 240 Preproc
> > headers 24.101.225.120 233802 ns 0un
> > GEThttp://www.sny.ca/investing/institution_productdetails.a
> > sp?InvestmentProductID=5X 19:55:11.318 86 569
> > Authentication 24.101.225.120 233832 ns 0
> > unGEThttp://www.sny.ca/investing/institution_productdetails
> > .asp?InvestmentProductID=12X 19:55:54.075 43 812
> > Authentication 24.101.225.120 233958 ns 0
> > unGEThttp://www.sny.ca/investing/search.asp?
> > t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x=31&OrderB
> > yRSP.y=7
> >
> > I haven't a clue what all that means. My website used two
> > databases that i connected through without and ODBC
> > connection (i gave ADO the real path of the database file
> > on every open)
> >
> > The typial website had about 5-10 include files and i
> > always closed my rs at the end of every asp file.
> >
> > Throughout the site i use the CreateObject method (used on
> > all of the above listed files). I do not set them to null
> > at the end of hte asp file - should i?
> >
> > Anything else?
> >
> > I know in VB i can use the Unload command to unload the
> > form, and i can use hte END command to end the program
> > (albiet a crude way of doing so), is there anything like
> > this in asp?
> >
> > please help!
> >
> > Siomn
> > Join Bytes![/color]
>
>[/color]

If I understand you correctly, i think your asking if i do
anything to close the recordset or null the object
variables if the user hits the Stop button before the page
loads. If I'm right, the answer is no - how do i go about
doing that?

Simon
Join Bytes!
[color=blue]
>-----Original Message-----
>Are you doing anything to help limit the impact of[/color]
abandoned processes where[color=blue]
>the object hasn't been unloaded through your code?
>
>Not sure if that would cause your problem but it's worth[/color]
a thought.[color=blue]
>
>ASP.Net performs a cleanup for such things that I don't[/color]
believe ASP does.[color=blue]
>
>
>
>
>
>"Simon" <webmaster@sny.ca> wrote in message
>news:059f01c3472b$ca5093b0$a101280a@phx.gbl...[color=green]
>> My webhosting company cut off my website the other day
>> because i had "too many hanging processes"
>>
>> What does this mean and what can i do to prevent this[/color][/color]
from[color=blue][color=green]
>> happening. They gave me the following readout...
>>
>> X 13:02:32.954 24 844 933 Preproc headers
>> 24.101.225.120 111433 ns
>> 0 un GET
>>[/color][/color]
http://www.sny.ca/investing/institu...uctdetails.asp?[color=blue][color=green]
>> InvestmentProductID=12
>> X 13:02:40.626 24 837 261 Authentication
>> 24.101.225.120 111454 ns 0
>> un GET
>> http://www.sny.ca/investing/search.asp?
>> t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh
>> X 13:08:27.287 24 490 599 Authentication
>> 24.101.225.120 112977 ns 0
>> un GET
>> ResellersLive (4:52:21 PM):
>> http://www.sny.ca/investing/search.asp?
>> t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh
>> X 13:09:19.327 24 438 560 Authentication
>> 24.101.225.120 113243 ns 0
>> un GET
>> http://www.sny.ca/investing/search.asp?
>> t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh
>> X 13:48:50.103 22 067 783 Authentication
>> 24.101.225.120 126007 ns 0
>> un GET
>> http://www.sny.ca/investing/search.asp?
>> t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Refresh
>> X 13:49:06.738 22 051 149 Preproc headers
>> 24.101.225.120 126128 ns
>>
>> ResellersLive (4:52:23 PM): 0 un GET
>> http://www.sny.ca/X 19:50:43.529 354 357 Preproc
>> headers 24.101.225.120 232810 ns 0un
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_productdetails.a[color=blue][color=green]
>> sp?InvestmentProductID=5X 19:55:04.647 93 240[/color][/color]
Preproc[color=blue][color=green]
>> headers 24.101.225.120 233802 ns 0un
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_productdetails.a[color=blue][color=green]
>> sp?InvestmentProductID=5X 19:55:11.318 86 569
>> Authentication 24.101.225.120 233832 ns 0
>>[/color][/color]
unGEThttp://www.sny.ca/investing/institution_productdetails[color=blue][color=green]
>> .asp?InvestmentProductID=12X 19:55:54.075 43 812
>> Authentication 24.101.225.120 233958 ns 0
>> unGEThttp://www.sny.ca/investing/search.asp?
>>[/color][/color]
t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x=31&OrderB[color=blue][color=green]
>> yRSP.y=7
>>
>> I haven't a clue what all that means. My website used[/color][/color]
two[color=blue][color=green]
>> databases that i connected through without and ODBC
>> connection (i gave ADO the real path of the database[/color][/color]
file[color=blue][color=green]
>> on every open)
>>
>> The typial website had about 5-10 include files and i
>> always closed my rs at the end of every asp file.
>>
>> Throughout the site i use the CreateObject method (used[/color][/color]
on[color=blue][color=green]
>> all of the above listed files). I do not set them to[/color][/color]
null[color=blue][color=green]
>> at the end of hte asp file - should i?
>>
>> Anything else?
>>
>> I know in VB i can use the Unload command to unload the
>> form, and i can use hte END command to end the program
>> (albiet a crude way of doing so), is there anything like
>> this in asp?
>>
>> please help!
>>
>> Siomn
>> Join Bytes![/color]
>
>
>.
>[/color]

I'd love to upgrade, but i cant afford VStudio.NET so i'm
just trying to make do for now.

As for my host they're not saying. They're only response
is "everything we found is explained up there (in the IIS
Trace readout)" and "you need to ask your programmer that".

I can easily quote them because their only means of "real-
time" tech support is through IM. - You get what you pay
for.

As for the database, i dont create a database object... i
open the recordset as follows....

<html>
<body>
<%
Option Explicit

Dim sConnectionString
sConnectionSring = "Driver={Microsoft Access Driver
(*.mdb)};DBQ=" & Server.MapPath("../cgi-bin/sny.mdb") & ";"

Dim rs
Set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Institutions",sConnectionSring
rs.MoveFirst
Response.Write rs("InstitutionName")
rs.Close

%>
</body>
</html>


Well okay, maybe my webpages arn't that dull, but besides
the standard html, thats about it. Anything i can do to
keep "this is unacceptable" website from crashing?

[color=blue]
>-----Original Message-----
>Not only that but the connection to the database should[/color]
be closed while the[color=blue]
>user is working with the dataset.
>
>It sounds like your application is an ideal candidate for[/color]
upgrade to[color=blue]
>ASP.Net. vs just ASP.
>
>
>
>
>
>
>"Simon" <webmaster@sny.ca> wrote in message
>news:02a601c3472f$df594370$a601280a@phx.gbl...[color=green]
>> If I understand you correctly, i think your asking if i[/color][/color]
do[color=blue][color=green]
>> anything to close the recordset or null the object
>> variables if the user hits the Stop button before the[/color][/color]
page[color=blue][color=green]
>> loads. If I'm right, the answer is no - how do i go[/color][/color]
about[color=blue][color=green]
>> doing that?
>>
>> Simon
>> Join Bytes!
>>[color=darkred]
>> >-----Original Message-----
>> >Are you doing anything to help limit the impact of[/color]
>> abandoned processes where[color=darkred]
>> >the object hasn't been unloaded through your code?
>> >
>> >Not sure if that would cause your problem but it's[/color][/color][/color]
worth[color=blue][color=green]
>> a thought.[color=darkred]
>> >
>> >ASP.Net performs a cleanup for such things that I don't[/color]
>> believe ASP does.[color=darkred]
>> >
>> >
>> >
>> >
>> >
>> >"Simon" <webmaster@sny.ca> wrote in message
>> >news:059f01c3472b$ca5093b0$a101280a@phx.gbl...
>> >> My webhosting company cut off my website the other[/color][/color][/color]
day[color=blue][color=green][color=darkred]
>> >> because i had "too many hanging processes"
>> >>
>> >> What does this mean and what can i do to prevent this[/color]
>> from[color=darkred]
>> >> happening. They gave me the following readout...
>> >>
>> >> X 13:02:32.954 24 844 933 Preproc headers
>> >> 24.101.225.120 111433 ns
>> >> 0 un GET
>> >>[/color]
>>[/color][/color]
http://www.sny.ca/investing/institu...uctdetails.asp?[color=blue][color=green][color=darkred]
>> >> InvestmentProductID=12
>> >> X 13:02:40.626 24 837 261 Authentication
>> >> 24.101.225.120 111454 ns 0
>> >> un GET
>> >> http://www.sny.ca/investing/search.asp?
>> >>[/color][/color][/color]
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh[color=blue][color=green][color=darkred]
>> >> X 13:08:27.287 24 490 599 Authentication
>> >> 24.101.225.120 112977 ns 0
>> >> un GET
>> >> ResellersLive (4:52:21 PM):
>> >> http://www.sny.ca/investing/search.asp?
>> >>[/color][/color][/color]
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh[color=blue][color=green][color=darkred]
>> >> X 13:09:19.327 24 438 560 Authentication
>> >> 24.101.225.120 113243 ns 0
>> >> un GET
>> >> http://www.sny.ca/investing/search.asp?
>> >>[/color][/color][/color]
t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh[color=blue][color=green][color=darkred]
>> >> X 13:48:50.103 22 067 783 Authentication
>> >> 24.101.225.120 126007 ns 0
>> >> un GET
>> >> http://www.sny.ca/investing/search.asp?
>> >>[/color][/color][/color]
t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Refresh[color=blue][color=green][color=darkred]
>> >> X 13:49:06.738 22 051 149 Preproc headers
>> >> 24.101.225.120 126128 ns
>> >>
>> >> ResellersLive (4:52:23 PM): 0 un GET
>> >> http://www.sny.ca/X 19:50:43.529 354 357 Preproc
>> >> headers 24.101.225.120 232810 ns 0un
>> >>[/color]
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_productdetails.a[color=blue][color=green][color=darkred]
>> >> sp?InvestmentProductID=5X 19:55:04.647 93 240[/color]
>> Preproc[color=darkred]
>> >> headers 24.101.225.120 233802 ns 0un
>> >>[/color]
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_productdetails.a[color=blue][color=green][color=darkred]
>> >> sp?InvestmentProductID=5X 19:55:11.318 86 569
>> >> Authentication 24.101.225.120 233832 ns 0
>> >>[/color]
>>[/color][/color]
unGEThttp://www.sny.ca/investing/institution_productdetails[color=blue][color=green][color=darkred]
>> >> .asp?InvestmentProductID=12X 19:55:54.075 43 812
>> >> Authentication 24.101.225.120 233958 ns 0
>> >> unGEThttp://www.sny.ca/investing/search.asp?
>> >>[/color]
>>[/color][/color]
t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x=31&OrderB[color=blue][color=green][color=darkred]
>> >> yRSP.y=7
>> >>
>> >> I haven't a clue what all that means. My website used[/color]
>> two[color=darkred]
>> >> databases that i connected through without and ODBC
>> >> connection (i gave ADO the real path of the database[/color]
>> file[color=darkred]
>> >> on every open)
>> >>
>> >> The typial website had about 5-10 include files and i
>> >> always closed my rs at the end of every asp file.
>> >>
>> >> Throughout the site i use the CreateObject method[/color][/color][/color]
(used[color=blue][color=green]
>> on[color=darkred]
>> >> all of the above listed files). I do not set them to[/color]
>> null[color=darkred]
>> >> at the end of hte asp file - should i?
>> >>
>> >> Anything else?
>> >>
>> >> I know in VB i can use the Unload command to unload[/color][/color][/color]
the[color=blue][color=green][color=darkred]
>> >> form, and i can use hte END command to end the[/color][/color][/color]
program[color=blue][color=green][color=darkred]
>> >> (albiet a crude way of doing so), is there anything[/color][/color][/color]
like[color=blue][color=green][color=darkred]
>> >> this in asp?
>> >>
>> >> please help!
>> >>
>> >> Siomn
>> >> Join Bytes!
>> >
>> >
>> >.
>> >[/color][/color]
>
>
>.
>[/color]

Don't forget
Set rs = nothing
This is vital.

Bob Barrows
Simon wrote:[color=blue]
> I'd love to upgrade, but i cant afford VStudio.NET so i'm
> just trying to make do for now.
>
> As for my host they're not saying. They're only response
> is "everything we found is explained up there (in the IIS
> Trace readout)" and "you need to ask your programmer that".
>
> I can easily quote them because their only means of "real-
> time" tech support is through IM. - You get what you pay
> for.
>
> As for the database, i dont create a database object... i
> open the recordset as follows....
>
> <html>
> <body>
> <%
> Option Explicit
>
> Dim sConnectionString
> sConnectionSring = "Driver={Microsoft Access Driver
> (*.mdb)};DBQ=" & Server.MapPath("../cgi-bin/sny.mdb") & ";"
>
> Dim rs
> Set rs = Server.CreateObject("ADODB.recordset")
> rs.Open "Institutions",sConnectionSring
> rs.MoveFirst
> Response.Write rs("InstitutionName")
> rs.Close
>
> %>
> </body>
> </html>
>
>
> Well okay, maybe my webpages arn't that dull, but besides
> the standard html, thats about it. Anything i can do to
> keep "this is unacceptable" website from crashing?
>
>[color=green]
>> -----Original Message-----
>> Not only that but the connection to the database should be closed
>> while the user is working with the dataset.
>>
>> It sounds like your application is an ideal candidate for upgrade to
>> ASP.Net. vs just ASP.
>>
>>
>>
>>
>>
>>
>> "Simon" <webmaster@sny.ca> wrote in message
>> news:02a601c3472f$df594370$a601280a@phx.gbl...[color=darkred]
>>> If I understand you correctly, i think your asking if i do
>>> anything to close the recordset or null the object
>>> variables if the user hits the Stop button before the page
>>> loads. If I'm right, the answer is no - how do i go about
>>> doing that?
>>>
>>> Simon
>>> Join Bytes!
>>>
>>>> -----Original Message-----
>>>> Are you doing anything to help limit the impact of abandoned
>>>> processes where the object hasn't been unloaded through your code?
>>>>
>>>> Not sure if that would cause your problem but it's worth a thought.
>>>>
>>>> ASP.Net performs a cleanup for such things that I don't believe
>>>> ASP does.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> "Simon" <webmaster@sny.ca> wrote in message
>>>> news:059f01c3472b$ca5093b0$a101280a@phx.gbl...
>>>>> My webhosting company cut off my website the other day
>>>>> because i had "too many hanging processes"
>>>>>
>>>>> What does this mean and what can i do to prevent this from
>>>>> happening. They gave me the following readout...
>>>>>
>>>>> X 13:02:32.954 24 844 933 Preproc headers
>>>>> 24.101.225.120 111433 ns
>>>>> 0 un GET
>>>>>
>>>[/color][/color]
> http://www.sny.ca/investing/institu...uctdetails.asp?[color=green][color=darkred]
>>>>> InvestmentProductID=12
>>>>> X 13:02:40.626 24 837 261 Authentication
>>>>> 24.101.225.120 111454 ns 0
>>>>> un GET
>>>>> http://www.sny.ca/investing/search.asp?
>>>>>[/color][/color]
> t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh[color=green][color=darkred]
>>>>> X 13:08:27.287 24 490 599 Authentication
>>>>> 24.101.225.120 112977 ns 0
>>>>> un GET
>>>>> ResellersLive (4:52:21 PM):
>>>>> http://www.sny.ca/investing/search.asp?
>>>>>[/color][/color]
> t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh[color=green][color=darkred]
>>>>> X 13:09:19.327 24 438 560 Authentication
>>>>> 24.101.225.120 113243 ns 0
>>>>> un GET
>>>>> http://www.sny.ca/investing/search.asp?
>>>>>[/color][/color]
> t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh[color=green][color=darkred]
>>>>> X 13:48:50.103 22 067 783 Authentication
>>>>> 24.101.225.120 126007 ns 0
>>>>> un GET
>>>>> http://www.sny.ca/investing/search.asp?
>>>>>[/color][/color]
> t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Refresh[color=green][color=darkred]
>>>>> X 13:49:06.738 22 051 149 Preproc headers
>>>>> 24.101.225.120 126128 ns
>>>>>
>>>>> ResellersLive (4:52:23 PM): 0 un GET
>>>>> http://www.sny.ca/X 19:50:43.529 354 357 Preproc
>>>>> headers 24.101.225.120 232810 ns 0un
>>>>>
>>>[/color][/color]
> GEThttp://www.sny.ca/investing/institution_productdetails.a[color=green][color=darkred]
>>>>> sp?InvestmentProductID=5X 19:55:04.647 93 240 Preproc
>>>>> headers 24.101.225.120 233802 ns 0un
>>>>>
>>>[/color][/color]
> GEThttp://www.sny.ca/investing/institution_productdetails.a[color=green][color=darkred]
>>>>> sp?InvestmentProductID=5X 19:55:11.318 86 569
>>>>> Authentication 24.101.225.120 233832 ns 0
>>>>>
>>>[/color][/color]
> unGEThttp://www.sny.ca/investing/institution_productdetails[color=green][color=darkred]
>>>>> .asp?InvestmentProductID=12X 19:55:54.075 43 812
>>>>> Authentication 24.101.225.120 233958 ns 0
>>>>> unGEThttp://www.sny.ca/investing/search.asp?
>>>>>
>>>[/color][/color]
> t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x=31&OrderB[color=green][color=darkred]
>>>>> yRSP.y=7
>>>>>
>>>>> I haven't a clue what all that means. My website used two
>>>>> databases that i connected through without and ODBC
>>>>> connection (i gave ADO the real path of the database file
>>>>> on every open)
>>>>>
>>>>> The typial website had about 5-10 include files and i
>>>>> always closed my rs at the end of every asp file.
>>>>>
>>>>> Throughout the site i use the CreateObject method (used on
>>>>> all of the above listed files). I do not set them to null
>>>>> at the end of hte asp file - should i?
>>>>>
>>>>> Anything else?
>>>>>
>>>>> I know in VB i can use the Unload command to unload the
>>>>> form, and i can use hte END command to end the program
>>>>> (albiet a crude way of doing so), is there anything like
>>>>> this in asp?
>>>>>
>>>>> please help!
>>>>>
>>>>> Siomn
>>>>> Join Bytes!
>>>>
>>>>
>>>> .
>>>>[/color]
>>
>>
>> .[/color][/color]

Kewl, I'll give it a try. Hopefully i wont get cut off
this time. Thanks Joe and Bob for all your help!

Best wishes,

Simon
[color=blue]
>-----Original Message-----
>It's been reported as being a leading cause of memory[/color]
leaks which can lead[color=blue]
>to "hung" servers.
>
>Bob
>
>Simon wrote:[color=green]
>> Ahh.. okay so i doo need to clear my object variables...
>> its all falling into place.... :-)
>>
>> So by me not doing this, would this create those hung
>> processes?
>>[color=darkred]
>>> -----Original Message-----
>>> Don't forget
>>> Set rs = nothing
>>> This is vital.
>>>
>>> Bob Barrows
>>> Simon wrote:
>>>> I'd love to upgrade, but i cant afford VStudio.NET so[/color][/color][/color]
i'm[color=blue][color=green][color=darkred]
>>>> just trying to make do for now.
>>>>
>>>> As for my host they're not saying. They're only[/color][/color][/color]
response[color=blue][color=green][color=darkred]
>>>> is "everything we found is explained up there (in the[/color][/color][/color]
IIS[color=blue][color=green][color=darkred]
>>>> Trace readout)" and "you need to ask your programmer[/color][/color][/color]
that".[color=blue][color=green][color=darkred]
>>>>
>>>> I can easily quote them because their only means[/color]
>> of "real-[color=darkred]
>>>> time" tech support is through IM. - You get what you[/color][/color][/color]
pay[color=blue][color=green][color=darkred]
>>>> for.
>>>>
>>>> As for the database, i dont create a database[/color][/color][/color]
object... i[color=blue][color=green][color=darkred]
>>>> open the recordset as follows....
>>>>
>>>> <html>
>>>> <body>
>>>> <%
>>>> Option Explicit
>>>>
>>>> Dim sConnectionString
>>>> sConnectionSring = "Driver={Microsoft Access Driver
>>>> (*.mdb)};DBQ=" & Server.MapPath("../cgi-bin/sny.mdb")[/color]
>> & ";"[color=darkred]
>>>>
>>>> Dim rs
>>>> Set rs = Server.CreateObject("ADODB.recordset")
>>>> rs.Open "Institutions",sConnectionSring
>>>> rs.MoveFirst
>>>> Response.Write rs("InstitutionName")
>>>> rs.Close
>>>>
>>>> %>
>>>> </body>
>>>> </html>
>>>>
>>>>
>>>> Well okay, maybe my webpages arn't that dull, but[/color][/color][/color]
besides[color=blue][color=green][color=darkred]
>>>> the standard html, thats about it. Anything i can do[/color][/color][/color]
to[color=blue][color=green][color=darkred]
>>>> keep "this is unacceptable" website from crashing?
>>>>
>>>>
>>>>> -----Original Message-----
>>>>> Not only that but the connection to the database[/color][/color][/color]
should be closed[color=blue][color=green][color=darkred]
>>>>> while the user is working with the dataset.
>>>>>
>>>>> It sounds like your application is an ideal[/color][/color][/color]
candidate for upgrade[color=blue][color=green][color=darkred]
>>>>> to ASP.Net. vs just ASP.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> "Simon" <webmaster@sny.ca> wrote in message
>>>>> news:02a601c3472f$df594370$a601280a@phx.gbl...
>>>>>> If I understand you correctly, i think your asking[/color][/color][/color]
if i do[color=blue][color=green][color=darkred]
>>>>>> anything to close the recordset or null the object
>>>>>> variables if the user hits the Stop button before[/color][/color][/color]
the page[color=blue][color=green][color=darkred]
>>>>>> loads. If I'm right, the answer is no - how do i go[/color][/color][/color]
about[color=blue][color=green][color=darkred]
>>>>>> doing that?
>>>>>>
>>>>>> Simon
>>>>>> Join Bytes!
>>>>>>
>>>>>>> -----Original Message-----
>>>>>>> Are you doing anything to help limit the impact of[/color][/color][/color]
abandoned[color=blue][color=green][color=darkred]
>>>>>>> processes where the object hasn't been unloaded[/color][/color][/color]
through your[color=blue][color=green][color=darkred]
>>>>>>> code?
>>>>>>>
>>>>>>> Not sure if that would cause your problem but it's[/color][/color][/color]
worth a[color=blue][color=green][color=darkred]
>>>>>>> thought.
>>>>>>>
>>>>>>> ASP.Net performs a cleanup for such things that I[/color][/color][/color]
don't believe[color=blue][color=green][color=darkred]
>>>>>>> ASP does.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> "Simon" <webmaster@sny.ca> wrote in message
>>>>>>> news:059f01c3472b$ca5093b0$a101280a@phx.gbl...
>>>>>>>> My webhosting company cut off my website the[/color][/color][/color]
other day[color=blue][color=green][color=darkred]
>>>>>>>> because i had "too many hanging processes"
>>>>>>>>
>>>>>>>> What does this mean and what can i do to prevent[/color][/color][/color]
this from[color=blue][color=green][color=darkred]
>>>>>>>> happening. They gave me the following readout...
>>>>>>>>
>>>>>>>> X 13:02:32.954 24 844 933 Preproc headers
>>>>>>>> 24.101.225.120 111433 ns
>>>>>>>> 0 un GET
>>>>>>>>
>>>>>>
>>>>[/color]
>>[/color][/color]
http://www.sny.ca/investing/institu...uctdetails.asp?[color=blue][color=green][color=darkred]
>>>>>>>> InvestmentProductID=12
>>>>>>>> X 13:02:40.626 24 837 261 Authentication
>>>>>>>> 24.101.225.120 111454 ns 0
>>>>>>>> un GET
>>>>>>>> http://www.sny.ca/investing/search.asp?
>>>>>>>>
>>>>[/color][/color][/color]
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh[color=blue][color=green][color=darkred]
>>>>>>>> X 13:08:27.287 24 490 599 Authentication
>>>>>>>> 24.101.225.120 112977 ns 0
>>>>>>>> un GET
>>>>>>>> ResellersLive (4:52:21 PM):
>>>>>>>> http://www.sny.ca/investing/search.asp?
>>>>>>>>
>>>>[/color][/color][/color]
t=30&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh[color=blue][color=green][color=darkred]
>>>>>>>> X 13:09:19.327 24 438 560 Authentication
>>>>>>>> 24.101.225.120 113243 ns 0
>>>>>>>> un GET
>>>>>>>> http://www.sny.ca/investing/search.asp?
>>>>>>>>
>>>>[/color][/color][/color]
t=0&MinInvestment=1&RSPEligibility=2&cmdRefresh=Refresh[color=blue][color=green][color=darkred]
>>>>>>>> X 13:48:50.103 22 067 783 Authentication
>>>>>>>> 24.101.225.120 126007 ns 0
>>>>>>>> un GET
>>>>>>>> http://www.sny.ca/investing/search.asp?
>>>>>>>>
>>>>[/color][/color][/color]
t=0&MinInvestment=0&RSPEligibility=2&cmdRefresh=Refresh[color=blue][color=green][color=darkred]
>>>>>>>> X 13:49:06.738 22 051 149 Preproc headers
>>>>>>>> 24.101.225.120 126128 ns
>>>>>>>>
>>>>>>>> ResellersLive (4:52:23 PM): 0 un GET
>>>>>>>> http://www.sny.ca/X 19:50:43.529 354 357[/color][/color][/color]
Preproc[color=blue][color=green][color=darkred]
>>>>>>>> headers 24.101.225.120 232810 ns 0un
>>>>>>>>
>>>>>>
>>>>[/color]
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_productdetails.a[color=blue][color=green][color=darkred]
>>>>>>>> sp?InvestmentProductID=5X 19:55:04.647 93 240[/color][/color][/color]
Preproc[color=blue][color=green][color=darkred]
>>>>>>>> headers 24.101.225.120 233802 ns 0un
>>>>>>>>
>>>>>>
>>>>[/color]
>>[/color][/color]
GEThttp://www.sny.ca/investing/institution_productdetails.a[color=blue][color=green][color=darkred]
>>>>>>>> sp?InvestmentProductID=5X 19:55:11.318 86 569
>>>>>>>> Authentication 24.101.225.120 233832 ns 0
>>>>>>>>
>>>>>>
>>>>[/color]
>>[/color][/color]
unGEThttp://www.sny.ca/investing/institution_productdetails[color=blue][color=green][color=darkred]
>>>>>>>> .asp?InvestmentProductID=12X 19:55:54.075 43 812
>>>>>>>> Authentication 24.101.225.120 233958 ns 0
>>>>>>>> unGEThttp://www.sny.ca/investing/search.asp?
>>>>>>>>
>>>>>>
>>>>[/color]
>>[/color][/color]
t=0&MinInvestment=0&RSPEligibility=0&OrderByRSP.x=31&OrderB[color=blue][color=green][color=darkred]
>>>>>>>> yRSP.y=7
>>>>>>>>
>>>>>>>> I haven't a clue what all that means. My website[/color][/color][/color]
used two[color=blue][color=green][color=darkred]
>>>>>>>> databases that i connected through without and[/color][/color][/color]
ODBC[color=blue][color=green][color=darkred]
>>>>>>>> connection (i gave ADO the real path of the[/color][/color][/color]
database file[color=blue][color=green][color=darkred]
>>>>>>>> on every open)
>>>>>>>>
>>>>>>>> The typial website had about 5-10 include files[/color][/color][/color]
and i[color=blue][color=green][color=darkred]
>>>>>>>> always closed my rs at the end of every asp file.
>>>>>>>>
>>>>>>>> Throughout the site i use the CreateObject method[/color][/color][/color]
(used on[color=blue][color=green][color=darkred]
>>>>>>>> all of the above listed files). I do not set them[/color][/color][/color]
to null[color=blue][color=green][color=darkred]
>>>>>>>> at the end of hte asp file - should i?
>>>>>>>>
>>>>>>>> Anything else?
>>>>>>>>
>>>>>>>> I know in VB i can use the Unload command to[/color][/color][/color]
unload the[color=blue][color=green][color=darkred]
>>>>>>>> form, and i can use hte END command to end the[/color][/color][/color]
program[color=blue][color=green][color=darkred]
>>>>>>>> (albiet a crude way of doing so), is there[/color][/color][/color]
anything like[color=blue][color=green][color=darkred]
>>>>>>>> this in asp?
>>>>>>>>
>>>>>>>> please help!
>>>>>>>>
>>>>>>>> Siomn
>>>>>>>> Join Bytes!
>>>>>>>
>>>>>>>
>>>>>>> .
>>>>>>>
>>>>>
>>>>>
>>>>> .
>>>
>>>
>>>
>>> .[/color][/color]
>
>
>
>.
>[/color]

> I'd love to upgrade, but i cant afford VStudio.NET so i'm[color=blue]
> just trying to make do for now.[/color]

Surely you can afford notepad or web matrix (http://www.asp.net).