ASP service appears to shut down all the time

Tony

unread,

Sep 19, 2000, 3:00:00 AM9/19/00

to

Hello Experts,

ASP service appears to shut down all the time. It is not a high traffic
server, its running IIS5 advanced server with a odbc connection to a
Access2000 mdb.

This is happening almost every day?
When It works - it works fine and then it doesn't it doesn't.

It only affects asp pages on this site http://207.139.83.37 no matter which
database the connection is with (I have two database connections for this
web)

I cant even attribute it to any specific task that makes this
happen.

It seems that other sites with ASP scripts on the same server
still works fine.

The only thing that gets it going is a server restart.

Any input in avoiding this is really appreciated.

Cheers
Tony

Tom Pepper

unread,

Sep 19, 2000, 3:00:00 AM9/19/00

to

This can be caused by:

1) Poor scripting
2) Too many simultaneous connections.
3) Connections not closing properly.
4) Not enough server memory.

--

Tom Pepper
MVG - Most Valuable Grump:
Over Half a Century of
Cantankerousness
---
Tony wrote in message ...

Chad Myers

unread,

Sep 19, 2000, 3:00:00 AM9/19/00

to

What leads you to believe the "ASP service... shut[s] down"?

What error(s) do you get when this happens?

-Chad

"Tony" <ttu...@yahoo.com> wrote in message news:utVtOtmIAHA.255@cppssbbsa04...

Thomas A. Rowe

unread,

Sep 19, 2000, 3:00:00 AM9/19/00

to

Try running a repair on the DB.

--

=====================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, Email Discussion List,
Newsletter, WebRing, MS KB Quick Links, etc.

Tony

unread,

Sep 19, 2000, 3:00:00 AM9/19/00

to

I've done a repair on the mdb several times.
Is there a ASP validator available?
For those of us who don't know what we are doing...

Thanks for all your reply's

Tony

"Thomas A. Rowe" <tar...@noln.com> wrote in message
news:uASg67mIAHA.286@cppssbbsa05...

Chad Myers

unread,

Sep 19, 2000, 3:00:00 AM9/19/00

to

Tell us what errors your getting and perhaps we could give you
more information.

Vague references to "service shutting down" doesn't really
tell us much.

Post some sample code of how you're accessing this Access
db (DAO? ADO?)

-Chad

"Tony" <ttu...@yahoo.com> wrote in message news:ewCn3AnIAHA.277@cppssbbsa05...

Tony

unread,

Sep 19, 2000, 3:00:00 AM9/19/00

to

Thanks for your reply

Background.
I am using a FP2000 ecommerce add on called Storefront2000 and it seems to
work well except for this problem. There are several ASP pages that come
with storefront and I have changed several of them. There is no error...just
a time-out when selecting any of the asp pages on the site - through a
browser.

I believe I have isolated a page (only because I made some crazy adjustments
to it ) cut and paste some code from other pages from Storefront files.
Again they seem to work right now (after a restart) and they arbitrarily
shut down. I have added a connection.open and close here. Does this make
sense?
I have a FP database results webbot also on this page...will that aid the
problem?

<%@ Language="VBScript" %>

<html>
<head>
</head>
<body>

<%' Response.Buffer = TRUE
'Response.Clear
'Response.Expires = 0
session.LCID = Session("LCID")
%>

<%
Product_ID= Request.QueryString("Product_ID")
%>
<%
Dim DSN_Name
DSN_Name = Session("DSN_Name")
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open DSN_Name
SQL="SELECT * FROM product WHERE PRODUCT_ID= '" & PRODUCT_ID & "'"
Set RS = Connection.Execute(SQL)
%>

<% If Request("ORDER_FLAG") = "1" Then %>
<% If Request("Alert") = "0" Then %>
 
 
Thank You
 
<% If Request("Quantity") = "1" Then%><%= Request("Quantity") %>  
<%= Request("DESCRIPTION") %> <%= Request("MFG") %> has been added to
your order! 
<% ElseIf Request("Quantity") > "1" Then %><%= Request("Quantity") %>
 
<%= Request("DESCRIPTION") %> have been added to your order! 
<% End If %>
<%= Request("MESSAGE") %>
<% End If %>
<% If Request("Alert") = "1" Then %>

<%= Request("Quantity") %>
<% End If %>
<% End If %>

<% Else
'If Request.QueryString("ORDER_FLAG") = "1" Then
Response.Redirect"order.asp"
'If Request.QueryString("ORDER_FLAG") = "0" Then
Response.Redirect"default.asp"
%>

<%
Set RS = nothing
Connection.Close
Set Connection = Nothing
End If
%>

Thanks for your interest
Tony

"Chad Myers" <cmy...@NOSPAM.austin.rr.com> wrote in message
news:OyNqIwn...@cppssbbsa02.microsoft.com...

Eron Tarhay

unread,

Sep 19, 2000, 3:00:00 AM9/19/00

to

just a quick fyi, for future reference....

Most of the code you just posted (other than the stuff you made) is
protected by a copyright and the nice people over at StoreFront might get a
tad upset if they knew you where posting it up here on a newsgroup. I have
seen them kindly ask people not to do so on their own newsgroup.

Sorry I don't have any addition info about your problem....

Regards,
Eron :-)

"Tony" <ttu...@yahoo.com> wrote in message

news:#neQzEoIAHA.260@cppssbbsa05...

Tony

unread,

Sep 19, 2000, 3:00:00 AM9/19/00

to

I've amended the code to this: It seems to work but will it cause the asp
service to stop?

<%
Dim DSN_Name
DSN_Name = Session("DSN_Name")
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open DSN_Name
SQL="SELECT * FROM product WHERE PRODUCT_ID= '" & PRODUCT_ID & "'"
Set RS = Connection.Execute(SQL)
%>

<% If Request("ORDER_FLAG") = "1" Then %>
<% If Request("Alert") = "0" Then %>
 
 
Thank You
 
<% If Request("Quantity") = "1" Then%><%= Request("Quantity") %>  
<%= Request("DESCRIPTION") %> <%= Request("MFG") %> has been added to
your order! 
<% ElseIf Request("Quantity") > "1" Then %><%= Request("Quantity") %>
 
<%= Request("DESCRIPTION") %> have been added to your order! 
<% End If %>
<%= Request("MESSAGE") %>
<% End If %>
<% If Request("Alert") = "1" Then %>

<%= Request("Quantity") %>
<% End If %>
<% End If %>

<%

Shane Fowlkes

unread,

Sep 20, 2000, 3:00:00 AM9/20/00

to

I'm sure the code he posted was copyrighted...it's pretty standard stuff.
In any event, he should be asking SF NG since he altered the code. The
error is most likely coming from the second <% %> parameters.

--
Shane Fowlkes
Accelerated Computer Technologies
www.acceleratedcomputers.com
(See FrontPage Tips at this web site.)

Eron Tarhay <sup...@vcconcepts.com> wrote in message
news:eyPZf#oIAHA.276@cppssbbsa04...

> just a quick fyi, for future reference....
>
> Most of the code you just posted (other than the stuff you made) is
> protected by a copyright and the nice people over at StoreFront might get
a
> tad upset if they knew you where posting it up here on a newsgroup. I have
> seen them kindly ask people not to do so on their own newsgroup.
>
> Sorry I don't have any addition info about your problem....
>
> Regards,
> Eron :-)
>
>
>
>

Tony Spratt

unread,

Sep 20, 2000, 3:00:00 AM9/20/00

to

Tony,

I think the problem may be with the <%Response.Redirect...%> code - I seem
to remember reading that you can't use Response.Redirect after the HTML
header has been written to the browser. Try replacing all Response.Redirect
code with something like:

<%
Response.Write "<Script
Language='jscript'>document.location='http://whatever...'</script>"
%>

You'll have to play about with the above to get it working.

HTH

Tony Spratt.

Tony

unread,

Sep 20, 2000, 3:00:00 AM9/20/00

to

Is there any way to tell if a connection has been left open. (on the server
or any other way)?

"Tony Spratt" <tony_...@jltgroup.com> wrote in message
news:O93dUDwIAHA.196@cppssbbsa05...

Thomas A. Rowe

unread,

Sep 20, 2000, 3:00:00 AM9/20/00

to

Response.Redirect is not the problem.

--

=====================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, Email Discussion List,
Newsletter, WebRing, MS KB Quick Links, etc.

"Tony Spratt" <tony_...@jltgroup.com> wrote in message