ASP pages not rendering

[Alan Easton]

Hello People,

I have a strange problem, one has been asked a few times
on the ASP general list.

But my SQL DB hosts say the problem is an Open Connection
problem. What happens is this, I have a complete ASP site
driven by a MS SQL DB, but every so often, ASP Pages stop
responding, no timeouts, not error messages, nothing at
all. HTML are fine, but not ASP, not even ASP with a
simple response.write are rendered.

Now my hosts say it can be caused by a few pages having
their DB connection left open, they say over a few weeks,
these can stack up, and IIS will not open any more, and
ASP will hang....????......I am not convinced by this
logic........

Have you guys and gals got any idea, I'm fresh out of
them.

Any help would be greatly appreciated.

Alan...

[Bob Barrows]

Alan Easton wrote:

> Hello People,
>
> I have a strange problem, one has been asked a few times
> on the ASP general list.
>
> But my SQL DB hosts say the problem is an Open Connection
> problem. What happens is this, I have a complete ASP site
> driven by a MS SQL DB, but every so often, ASP Pages stop
> responding, no timeouts, not error messages, nothing at
> all. HTML are fine, but not ASP, not even ASP with a
> simple response.write are rendered.
>
> Now my hosts say it can be caused by a few pages having
> their DB connection left open, they say over a few weeks,
> these can stack up, and IIS will not open any more, and
> ASP will hang....????......I am not convinced by this
> logic........
>

They could very well be right. Why aren't you convinced? This is one of the
common causes of hang-ups in IIS.

Are you explicitly closing and destroying your ADO objects in your ASP code?
or are you simply leaving them to be destroyed when the pages go out of
scope? Memory leaks can result from objects failing to be destroyed by the
automatic cleanup code. Memory leaks which can eventually lead to crashes of
inetinfo (iis).

Aside from that, this page lists a few other causes of this problem:
[url]http://www.aspfaq.com/show.asp?id=2147[/url]

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Alan Easton]

Hi Bob,

Thanks for the reply. The reason I am not convinced is
that at the end of all my files, I have an include file
that closes the DB connection, just like I have an
include file at the beginning that opens it.

Now I have checked all my files, but perhaps one or two I
have missed, again, I am not convinced that 1 or 2 files
can cause this to happen over the period of a week. Plus,
it has happened over the space of 24hrs as well, then it
will right itself.

It happened at 11pm last night, then when I checked again
this morning, it was fine.

I just don't see, even if I have left a few connections
open, which believe me I have checked and checked, can
bring the site not to render over a week.

Any other ideas will be appreciated, I have seen the page
you sent and have already forwarded onto my hosts.

Thanks,

Alan...

>-----Original Message-----
>Alan Easton wrote:

>> Hello People,
>>
>> I have a strange problem, one has been asked a few

times

>> on the ASP general list.
>>
>> But my SQL DB hosts say the problem is an Open

Connection

>> problem. What happens is this, I have a complete ASP

site

>> driven by a MS SQL DB, but every so often, ASP Pages

stop

>> responding, no timeouts, not error messages, nothing at
>> all. HTML are fine, but not ASP, not even ASP with a
>> simple response.write are rendered.
>>
>> Now my hosts say it can be caused by a few pages having
>> their DB connection left open, they say over a few

weeks,

>> these can stack up, and IIS will not open any more, and
>> ASP will hang....????......I am not convinced by this
>> logic........
>>

>They could very well be right. Why aren't you convinced?

This is one of the

>common causes of hang-ups in IIS.
>
>Are you explicitly closing and destroying your ADO

objects in your ASP code?

>or are you simply leaving them to be destroyed when the

pages go out of

>scope? Memory leaks can result from objects failing to

be destroyed by the

>automatic cleanup code. Memory leaks which can

eventually lead to crashes of

>inetinfo (iis).
>
>Aside from that, this page lists a few other causes of

this problem:

>[url]http://www.aspfaq.com/show.asp?id=2147[/url]
>
>HTH,
>Bob Barrows
>
>--
>Microsoft MVP - ASP/ASP.NET
>Please reply to the newsgroup. This email account is my

spam trap so I

>don't check it very often. If you must reply off-line,

then remove the

>"NO SPAM"
>
>
>.
>

[Bob Barrows]

Alan Easton wrote:

> Hi Bob,
>
> Thanks for the reply. The reason I am not convinced is
> that at the end of all my files, I have an include file
> that closes the DB connection, just like I have an
> include file at the beginning that opens it.

How about recordset objects? Do you explicitly close AND DESTROY them as
well? If a recordset is still open and in the process of doing something,
the connection may not be close-able. An error will be raised when the
attempt to close it is made, but since your page is out of scope, there will
be nothing to respond to the error and the connection will remain open,
causing memory to leak.

>
> Now I have checked all my files, but perhaps one or two I
> have missed, again, I am not convinced that 1 or 2 files
> can cause this to happen over the period of a week. Plus,

Why not? Once a memory leak begins, it keeps leaking.

> it has happened over the space of 24hrs as well, then it
> will right itself.
>
> It happened at 11pm last night, then when I checked again
> this morning, it was fine.
>

Ah! Now we have a clue that points against the memory leak scenario. They
usually will not fix themselves. However, we still can't rule it out: the
resources may be on the borderline of causing inetinfo to fail, perhaps
another process on the server finishes and releases its resources allowing
inetinfo to recover...

>
> Any other ideas will be appreciated, I have seen the page
> you sent and have already forwarded onto my hosts.
>

[url]http://support.microsoft.com?kbid=309051[/url]

Check out the IIS6 Resource Kit:
[url]http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en[/url]

Also, run IISState to capture your problem and have it looked at:
[url]http://www.iisfaq.com/default.aspx?view=P197[/url]


Bob Barrows


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Alan Easton]

Hi Bob,

Thanks again for the info.

The recordset problem is something I thought of as well,
and I do the same, close each one and set it to nothing.

Right now, at 15:18GMT, my site is currently down,
[url]http://www.sportnorthumbria.com[/url]. Now it was fine at about
13:00GMT, so why in the space of 2hrs, it is not
rendering ASP. There can be no way I generate the same
traffic in 2 hours that would cause ASP not to respond,
if it was an open connection problem, that is why I think
there is something else.

I do close my recordsets and my DB connections, and even
though my site as a whole does make alot of calls to the
DB, I don't understand why it runs fine over the period
of 10 days, then goes down twice in the space of 24hrs.

I appreciate your help Bob, the stuff you have sent me, I
will forward on to my hosts, unfortunately I cannot run
any of it, so it will be up to my hosts.

What about DB connectivity...???....could it be the
connection string I use...currently a DSN-Less
connection, are there better ones to use....

Thanks again for your opinions on this Bob.

Alan...

>-----Original Message-----
>Alan Easton wrote:

>> Hi Bob,
>>
>> Thanks for the reply. The reason I am not convinced is
>> that at the end of all my files, I have an include file
>> that closes the DB connection, just like I have an
>> include file at the beginning that opens it.

>
>How about recordset objects? Do you explicitly close AND

DESTROY them as

>well? If a recordset is still open and in the process of

doing something,

>the connection may not be close-able. An error will be

raised when the

>attempt to close it is made, but since your page is out

of scope, there will

>be nothing to respond to the error and the connection

will remain open,

>causing memory to leak.
>

>>
>> Now I have checked all my files, but perhaps one or

two I

>> have missed, again, I am not convinced that 1 or 2

files

>> can cause this to happen over the period of a week.

Plus,

>
>Why not? Once a memory leak begins, it keeps leaking.
>

>> it has happened over the space of 24hrs as well, then

it

>> will right itself.
>>
>> It happened at 11pm last night, then when I checked

again

>> this morning, it was fine.
>>

>
>Ah! Now we have a clue that points against the memory

leak scenario. They

>usually will not fix themselves. However, we still can't

rule it out: the

>resources may be on the borderline of causing inetinfo

to fail, perhaps

>another process on the server finishes and releases its

resources allowing

>inetinfo to recover...
>

>>
>> Any other ideas will be appreciated, I have seen the

page

>> you sent and have already forwarded onto my hosts.
>>

>[url]http://support.microsoft.com?kbid=309051[/url]
>
>Check out the IIS6 Resource Kit:
>[url]http://www.microsoft.com/downloads/details.aspx?[/url]

FamilyID=56fc92ee-a71a-4c73-b628-
ade629c89499&DisplayLang=en

>
>Also, run IISState to capture your problem and have it

looked at:

>[url]http://www.iisfaq.com/default.aspx?view=P197[/url]
>
>
>Bob Barrows
>
>
>--
>Microsoft MVP - ASP/ASP.NET
>Please reply to the newsgroup. This email account is my

spam trap so I

>don't check it very often. If you must reply off-line,

then remove the

>"NO SPAM"
>
>
>.
>

[Bob Barrows]

Alan Easton wrote:

> Hi Bob,
>
> Thanks again for the info.
>
> The recordset problem is something I thought of as well,
> and I do the same, close each one and set it to nothing.
>
> Right now, at 15:18GMT, my site is currently down,
> [url]http://www.sportnorthumbria.com[/url]. Now it was fine at about
> 13:00GMT, so why in the space of 2hrs, it is not
> rendering ASP. There can be no way I generate the same
> traffic in 2 hours that would cause ASP not to respond,
> if it was an open connection problem, that is why I think
> there is something else.
>
> I do close my recordsets and my DB connections, and even
> though my site as a whole does make alot of calls to the
> DB, I don't understand why it runs fine over the period
> of 10 days, then goes down twice in the space of 24hrs.
>
> I appreciate your help Bob, the stuff you have sent me, I
> will forward on to my hosts, unfortunately I cannot run
> any of it, so it will be up to my hosts.
>
> What about DB connectivity...???....could it be the
> connection string I use...currently a DSN-Less
> connection, are there better ones to use....

If you are using ODBC, then you would be better of switching to OLEDB if a
native OLEDB provider exists for your database. See
[url]www.able-consulting.com/ado_conn.htm[/url] for examples. But I am starting to
doubt that the ADO connections are the problem. If you are using SQL Server,
you can check to see if there are any orphaned connections ...

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Alan Easton]

Hi Bob,

Thanks again for the response.

I have sent my hosts the links you gave me. They have
replies with a response of: "We have stopped the Indexing
Service on this server as it was utilising almost 100% of
the servers CPU. This may have been causing the problem"

Any feelings on this. Could this be caused by my website??

My hosts, which have been very good, and myself will
continue to trouble-shoot this. If you think of anything
else, or know if the response they gave me highlights
anything, then please do let me know.

Much appreciated the time you have spent answering my
posts, this website is massively important to me.

Thanks again,

Alan...

>-----Original Message-----
>Alan Easton wrote:

>> Hi Bob,
>>
>> Thanks again for the info.
>>
>> The recordset problem is something I thought of as

well,

>> and I do the same, close each one and set it to

nothing.

>>
>> Right now, at 15:18GMT, my site is currently down,
>> [url]http://www.sportnorthumbria.com[/url]. Now it was fine at

about

>> 13:00GMT, so why in the space of 2hrs, it is not
>> rendering ASP. There can be no way I generate the same
>> traffic in 2 hours that would cause ASP not to respond,
>> if it was an open connection problem, that is why I

think

>> there is something else.
>>
>> I do close my recordsets and my DB connections, and

even

>> though my site as a whole does make alot of calls to

the

>> DB, I don't understand why it runs fine over the period
>> of 10 days, then goes down twice in the space of 24hrs.
>>
>> I appreciate your help Bob, the stuff you have sent

me, I

>> will forward on to my hosts, unfortunately I cannot run
>> any of it, so it will be up to my hosts.
>>
>> What about DB connectivity...???....could it be the
>> connection string I use...currently a DSN-Less
>> connection, are there better ones to use....

>
>If you are using ODBC, then you would be better of

switching to OLEDB if a

>native OLEDB provider exists for your database. See
>[url]www.able-consulting.com/ado_conn.htm[/url] for examples. But I

am starting to

>doubt that the ADO connections are the problem. If you

are using SQL Server,

>you can check to see if there are any orphaned

connections ...

>
>Bob Barrows
>--
>Microsoft MVP - ASP/ASP.NET
>Please reply to the newsgroup. This email account is my

spam trap so I

>don't check it very often. If you must reply off-line,

then remove the

>"NO SPAM"
>
>
>.
>

[Bob Barrows]

Alan Easton wrote:

> Hi Bob,
>
> Thanks again for the response.
>
> I have sent my hosts the links you gave me. They have
> replies with a response of: "We have stopped the Indexing
> Service on this server as it was utilising almost 100% of
> the servers CPU. This may have been causing the problem"
>
> Any feelings on this. Could this be caused by my website??
>

It could be, but it does not explain why html pages continued to be served
....

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Alan Easton]

Hi Bob,

Well, if that is you feeling about their response, I will
pass on your view as HTML pages are served no problem.

If you do have any other suggestions, please do mail me
at: [email]alaneaston666@hotmail.com[/email]

I am struggling to find a solution to this Bob so any
help whatsover would be greatly appreciated.

Many Thanks,

Alan...

>-----Original Message-----
>Alan Easton wrote:

>> Hi Bob,
>>
>> Thanks again for the response.
>>
>> I have sent my hosts the links you gave me. They have
>> replies with a response of: "We have stopped the

Indexing

>> Service on this server as it was utilising almost 100%

of

>> the servers CPU. This may have been causing the

problem"

>>
>> Any feelings on this. Could this be caused by my

website??

>>

>It could be, but it does not explain why html pages

continued to be served

>....
>
>Bob Barrows
>
>--
>Microsoft MVP - ASP/ASP.NET
>Please reply to the newsgroup. This email account is my

spam trap so I

>don't check it very often. If you must reply off-line,

then remove the

>"NO SPAM"
>
>
>.
>