|
 |
asp_databases thread: ASP NOT RESPONDING
Message #1 by "Jon Patterson" <jon.patterson@s...> on Tue, 13 Nov 2001 15:07:38
|
|
i thought this would happen with pre mdac 2.0 but our NT server is running
MDAC 2.6 so it shouldn't have this ODBC memory leak anymore, right?
the computer was just restarted yesterday and it is now not responding.
it used to take at least 2 weeks or more before this would happen.
maybe it's my open statements in asp.
if anyone can help much thanks is appreciated.
-jon
Message #2 by "Craig Flannigan" <ckf@k...> on Tue, 13 Nov 2001 15:08:08 -0000
|
|
Are you closing all connections you make to your databases?
Check that your code is not getting into a loop. Can you test to see if any
particular pages cause the instability?
What SP are you on for NT?
-----Original Message-----
From: Jon Patterson [mailto:jon.patterson@s...]
Sent: Tuesday 13 November 2001 15:08
To: ASP Databases
Subject: [asp_databases] ASP NOT RESPONDING
i thought this would happen with pre mdac 2.0 but our NT server is running
MDAC 2.6 so it shouldn't have this ODBC memory leak anymore, right?
the computer was just restarted yesterday and it is now not responding.
it used to take at least 2 weeks or more before this would happen.
maybe it's my open statements in asp.
if anyone can help much thanks is appreciated.
-jon
$subst('Email.Unsub')
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service. For further
information visit http://www.star.net.uk/stats.asp or alternatively call
Star Internet for details on the Virus Scanning Service.
Message #3 by Sam Clohesy <sam@e...> on Tue, 13 Nov 2001 15:19:12 -0000
|
|
Hi John we had a v similar prob (NT4, SQL 7 SP6a, Nimba code red etc) and no
real resolution apart from to free up disk space and increase virtual paging
memory
This is a fairly well documented problem (Search deja for IIS/ASP memory
leak)
We still have to restart every week, (Please let me know if you find a
permanenet solution)
Apologies for not being of more assistance
Thanks
Sam
Sam Clohesy
Project Manager
Tel: 0208 772 3958
E: samc@e...
W: http://www.etypemedia.co.uk
-----Original Message-----
From: Jon Patterson [mailto:jon.patterson@s...]
Sent: 13 November 2001 15:08
To: ASP Databases
Subject: [asp_databases] ASP NOT RESPONDING
i thought this would happen with pre mdac 2.0 but our NT server is running
MDAC 2.6 so it shouldn't have this ODBC memory leak anymore, right?
the computer was just restarted yesterday and it is now not responding.
it used to take at least 2 weeks or more before this would happen.
maybe it's my open statements in asp.
if anyone can help much thanks is appreciated.
-jon
$subst('Email.Unsub')
Message #4 by "Jon Patterson" <jon.patterson@s...> on Tue, 13 Nov 2001 15:40:11
|
|
Hi Craig,
We are running Service Pack 6a on our server.
I have been testing all my pages on my computer but when I transferred the
pages to the Server they don't respond. I changed the ODBC and nothing
happened.
I included code from one page of my asp app. I would appreciate it if
someone might be able to help me out with some pointers on coding.
<%
Dim objRS, strcompanyname, results, record, total, strproducts
Dim strDSN
strDSN = "DSN=WO_BE;UID=sa;PWD=pwd"
Set objRS = Server.CreateObject ("ADODB.Recordset")
objRS.Open "tblWorkOrders", strDSN, adOpenStatic, adLockOptimistic,
adCmdTable
strproducts = request.form("txtproduct")
Response.Write "<table width='520' border='1' align='center'
bgcolor='lightblue'><tr><td colspan='3'>"
Response.Write "<table width='520' border='1' align='center'
bgcolor='lightblue'><tr><td align='left' width='1%' height='1%'><img
src='workorderlogo.jpg'></td><td align='center' colspan='2'><font
face='Verdana'><div class='fixedfont2'>Work Order
Search</td></tr></table></td></tr>"
Response.Write "<tr><td colspan='4'><br><font face='Verdana'><div
class='fixedfont'><b><center>Search Results</b><br><br>"
Response.Write "<font face='Verdana'><div class='fixedfont'>You searched
for "<b>" & strproducts & "</b>"</center><br></td></tr>"
Response.Write "<tr><td bgcolor='white' align='center'><font
face='Verdana'><div class='fixedfont'><b>WO. #</td><td align='center'
bgcolor='white'><font face='Verdana'><div class='fixedfont'><b>Company
Name</td><td align='center' bgcolor='white'><font face='Verdana'><div
class='fixedfont'><b>Products</td></tr>"
record = 0
results = "productssamples LIKE '" & "*" & strproducts & "*'"
objRS.Filter = results
objRS.Find results
If Not objRS.EOF Then
While Not objRS.EOF
record = record + 1
Response.write "<tr><td align='center'
bgcolor='white'><font face='Verdana'><div class='fixedfont'><a
href=searchresults.asp?WO=" & objRS("Work_Order_No") & ">" & objRS
("Work_Order_No") & "</a>"
Response.Write "</td><td bgcolor='white'><font
face='Verdana'><div class='fixedfont'>"
Response.write objRS("companyname") & "</td><td
bgcolor='white'><font face='Verdana'><div class='fixedfont'>"
Response.write objRS("productssamples")
& "</td></tr>"
objRS.MoveNext
wend
Else
Response.Write "<br><tr><td colspan='3'
align='center' valign='middle' bgcolor='white'><br><font
face='Verdana'><div class='fixedfont'>Your Search Produced
"<b>0</b>" Results<br>"
End If
Response.Write "<br></table>"
total = record
response.write "<br><center><div class='fixedfont'><font
face='Verdana'>Your Search Returned <b>" & total & "</b> Records"
objRS.Close
Set objRS = Nothing
%>
> Are you closing all connections you make to your databases?
>
> Check that your code is not getting into a loop. Can you test to see if
any
> particular pages cause the instability?
>
> What SP are you on for NT?
>
> -----Original Message-----
> From: Jon Patterson [mailto:jon.patterson@s...]
> Sent: Tuesday 13 November 2001 15:08
> To: ASP Databases
> Subject: [asp_databases] ASP NOT RESPONDING
>
>
> i thought this would happen with pre mdac 2.0 but our NT server is
running
> MDAC 2.6 so it shouldn't have this ODBC memory leak anymore, right?
>
> the computer was just restarted yesterday and it is now not responding.
> it used to take at least 2 weeks or more before this would happen.
>
> maybe it's my open statements in asp.
>
> if anyone can help much thanks is appreciated.
>
> -jon
>
> $subst('Email.Unsub')
>
>
> _____________________________________________________________________
> This message has been checked for all known viruses by Star Internet
> delivered through the MessageLabs Virus Scanning Service. For further
> information visit http://www.star.net.uk/stats.asp or alternatively call
> Star Internet for details on the Virus Scanning Service.
>
Message #5 by "Craig Flannigan" <ckf@k...> on Wed, 14 Nov 2001 08:13:10 -0000
|
|
Hi,
Does it work properly on your computer?
Do simple ASP pages cause the server to not respond, or is it only happening
when you use pages that contain database connections?
Regards,
Craig.
-----Original Message-----
From: Jon Patterson [mailto:jon.patterson@s...]
Sent: Tuesday 13 November 2001 15:40
To: ASP Databases
Subject: [asp_databases] RE: ASP NOT RESPONDING
Hi Craig,
We are running Service Pack 6a on our server.
I have been testing all my pages on my computer but when I transferred the
pages to the Server they don't respond. I changed the ODBC and nothing
happened.
I included code from one page of my asp app. I would appreciate it if
someone might be able to help me out with some pointers on coding.
<%
Dim objRS, strcompanyname, results, record, total, strproducts
Dim strDSN
strDSN = "DSN=WO_BE;UID=sa;PWD=pwd"
Set objRS = Server.CreateObject ("ADODB.Recordset")
objRS.Open "tblWorkOrders", strDSN, adOpenStatic, adLockOptimistic,
adCmdTable
strproducts = request.form("txtproduct")
Response.Write "<table width='520' border='1' align='center'
bgcolor='lightblue'><tr><td colspan='3'>"
Response.Write "<table width='520' border='1' align='center'
bgcolor='lightblue'><tr><td align='left' width='1%' height='1%'><img
src='workorderlogo.jpg'></td><td align='center' colspan='2'><font
face='Verdana'><div class='fixedfont2'>Work Order
Search</td></tr></table></td></tr>"
Response.Write "<tr><td colspan='4'><br><font face='Verdana'><div
class='fixedfont'><b><center>Search Results</b><br><br>"
Response.Write "<font face='Verdana'><div class='fixedfont'>You searched
for "<b>" & strproducts & "</b>"</center><br></td></tr>"
Response.Write "<tr><td bgcolor='white' align='center'><font
face='Verdana'><div class='fixedfont'><b>WO. #</td><td align='center'
bgcolor='white'><font face='Verdana'><div class='fixedfont'><b>Company
Name</td><td align='center' bgcolor='white'><font face='Verdana'><div
class='fixedfont'><b>Products</td></tr>"
record = 0
results = "productssamples LIKE '" & "*" & strproducts & "*'"
objRS.Filter = results
objRS.Find results
If Not objRS.EOF Then
While Not objRS.EOF
record = record + 1
Response.write "<tr><td align='center'
bgcolor='white'><font face='Verdana'><div class='fixedfont'><a
href=searchresults.asp?WO=" & objRS("Work_Order_No") & ">" & objRS
("Work_Order_No") & "</a>"
Response.Write "</td><td bgcolor='white'><font
face='Verdana'><div class='fixedfont'>"
Response.write objRS("companyname") & "</td><td
bgcolor='white'><font face='Verdana'><div class='fixedfont'>"
Response.write objRS("productssamples")
& "</td></tr>"
objRS.MoveNext
wend
Else
Response.Write "<br><tr><td colspan='3'
align='center' valign='middle' bgcolor='white'><br><font
face='Verdana'><div class='fixedfont'>Your Search Produced
"<b>0</b>" Results<br>"
End If
Response.Write "<br></table>"
total = record
response.write "<br><center><div class='fixedfont'><font
face='Verdana'>Your Search Returned <b>" & total & "</b> Records"
objRS.Close
Set objRS = Nothing
%>
> Are you closing all connections you make to your databases?
>
> Check that your code is not getting into a loop. Can you test to see if
any
> particular pages cause the instability?
>
> What SP are you on for NT?
>
> -----Original Message-----
> From: Jon Patterson [mailto:jon.patterson@s...]
> Sent: Tuesday 13 November 2001 15:08
> To: ASP Databases
> Subject: [asp_databases] ASP NOT RESPONDING
>
>
> i thought this would happen with pre mdac 2.0 but our NT server is
running
> MDAC 2.6 so it shouldn't have this ODBC memory leak anymore, right?
>
> the computer was just restarted yesterday and it is now not responding.
> it used to take at least 2 weeks or more before this would happen.
>
> maybe it's my open statements in asp.
>
> if anyone can help much thanks is appreciated.
>
> -jon
>
> $subst('Email.Unsub')
>
>
> _____________________________________________________________________
> This message has been checked for all known viruses by Star Internet
> delivered through the MessageLabs Virus Scanning Service. For further
> information visit http://www.star.net.uk/stats.asp or alternatively call
> Star Internet for details on the Virus Scanning Service.
>
$subst('Email.Unsub')
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service. For further
information visit http://www.star.net.uk/stats.asp or alternatively call
Star Internet for details on the Virus Scanning Service.
Message #6 by "Jon Patterson" <jon.patterson@s...> on Wed, 14 Nov 2001 13:59:05
|
|
The simple asp pages don't respond either.
> Hi,
>
> Does it work properly on your computer?
>
> Do simple ASP pages cause the server to not respond, or is it only
happening
> when you use pages that contain database connections?
>
>
> Regards,
> Craig.
>
> -----Original Message-----
> From: Jon Patterson [mailto:jon.patterson@s...]
> Sent: Tuesday 13 November 2001 15:40
> To: ASP Databases
> Subject: [asp_databases] RE: ASP NOT RESPONDING
>
>
> Hi Craig,
>
> We are running Service Pack 6a on our server.
>
> I have been testing all my pages on my computer but when I transferred
the
> pages to the Server they don't respond. I changed the ODBC and nothing
> happened.
>
> I included code from one page of my asp app. I would appreciate it if
> someone might be able to help me out with some pointers on coding.
>
> <%
> Dim objRS, strcompanyname, results, record, total, strproducts
>
> Dim strDSN
> strDSN = "DSN=WO_BE;UID=sa;PWD=pwd"
>
>
>
> Set objRS = Server.CreateObject ("ADODB.Recordset")
> objRS.Open "tblWorkOrders", strDSN, adOpenStatic, adLockOptimistic,
> adCmdTable
>
> strproducts = request.form("txtproduct")
> Response.Write "<table width='520' border='1' align='center'
> bgcolor='lightblue'><tr><td colspan='3'>"
>
>
> Response.Write "<table width='520' border='1' align='center'
> bgcolor='lightblue'><tr><td align='left' width='1%' height='1%'><img
> src='workorderlogo.jpg'></td><td align='center' colspan='2'><font
> face='Verdana'><div class='fixedfont2'>Work Order
> Search</td></tr></table></td></tr>"
> Response.Write "<tr><td colspan='4'><br><font face='Verdana'><div
> class='fixedfont'><b><center>Search Results</b><br><br>"
>
> Response.Write "<font face='Verdana'><div class='fixedfont'>You searched
> for "<b>" & strproducts & "</b>"</center><br></td></tr>"
> Response.Write "<tr><td bgcolor='white' align='center'><font
> face='Verdana'><div class='fixedfont'><b>WO. #</td><td align='center'
> bgcolor='white'><font face='Verdana'><div class='fixedfont'><b>Company
> Name</td><td align='center' bgcolor='white'><font face='Verdana'><div
> class='fixedfont'><b>Products</td></tr>"
>
> record = 0
>
> results = "productssamples LIKE '" & "*" & strproducts & "*'"
> objRS.Filter = results
> objRS.Find results
> If Not objRS.EOF Then
> While Not objRS.EOF
> record = record + 1
> Response.write "<tr><td align='center'
> bgcolor='white'><font face='Verdana'><div class='fixedfont'><a
> href=searchresults.asp?WO=" & objRS("Work_Order_No") & ">" & objRS
> ("Work_Order_No") & "</a>"
> Response.Write "</td><td bgcolor='white'><font
> face='Verdana'><div class='fixedfont'>"
> Response.write objRS("companyname") & "</td><td
> bgcolor='white'><font face='Verdana'><div class='fixedfont'>"
> Response.write objRS("productssamples")
> & "</td></tr>"
>
> objRS.MoveNext
> wend
> Else
> Response.Write "<br><tr><td colspan='3'
> align='center' valign='middle' bgcolor='white'><br><font
> face='Verdana'><div class='fixedfont'>Your Search Produced
> "<b>0</b>" Results<br>"
> End If
>
> Response.Write "<br></table>"
>
> total = record
> response.write "<br><center><div class='fixedfont'><font
> face='Verdana'>Your Search Returned <b>" & total & "</b> Records"
>
> objRS.Close
>
> Set objRS = Nothing
>
> %>
>
> > Are you closing all connections you make to your databases?
> >
> > Check that your code is not getting into a loop. Can you test to see if
> any
> > particular pages cause the instability?
> >
> > What SP are you on for NT?
> >
> > -----Original Message-----
> > From: Jon Patterson [mailto:jon.patterson@s...]
> > Sent: Tuesday 13 November 2001 15:08
> > To: ASP Databases
> > Subject: [asp_databases] ASP NOT RESPONDING
> >
> >
> > i thought this would happen with pre mdac 2.0 but our NT server is
> running
> > MDAC 2.6 so it shouldn't have this ODBC memory leak anymore, right?
> >
> > the computer was just restarted yesterday and it is now not responding.
> > it used to take at least 2 weeks or more before this would happen.
> >
> > maybe it's my open statements in asp.
> >
> > if anyone can help much thanks is appreciated.
> >
> > -jon
> >
ckf@k...
> > $subst('Email.Unsub')
> >
> >
> > _____________________________________________________________________
> > This message has been checked for all known viruses by Star Internet
> > delivered through the MessageLabs Virus Scanning Service. For further
> > information visit http://www.star.net.uk/stats.asp or alternatively
call
> > Star Internet for details on the Virus Scanning Service.
> >
>
>
> $subst('Email.Unsub')
>
>
> _____________________________________________________________________
> This message has been checked for all known viruses by Star Internet
> delivered through the MessageLabs Virus Scanning Service. For further
> information visit http://www.star.net.uk/stats.asp or alternatively call
> Star Internet for details on the Virus Scanning Service.
>
Message #7 by "H=?ISO-8859-1?Q?=E5?=kan Frennesson" <Hakan@c...> on Wed, 14 Nov 2001 15:39:50 +0100
|
|
HI!
Did you try changing your wildcards from * to %?
results = "productssamples LIKE '" & "%" & strproducts & "%'"
Hakan
---------- Original Message ----------------------------------
From: "Jon Patterson" <jon.patterson@s...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date: Wed, 14 Nov 2001 13:59:05
>The simple asp pages don't respond either.
>
>> Hi,
>>
>> Does it work properly on your computer?
>>
>> Do simple ASP pages cause the server to not respond, or is it only
>happening
>> when you use pages that contain database connections?
>>
>>
>> Regards,
>> Craig.
>>
>> -----Original Message-----
>> From: Jon Patterson [mailto:jon.patterson@s...]
>> Sent: Tuesday 13 November 2001 15:40
>> To: ASP Databases
>> Subject: [asp_databases] RE: ASP NOT RESPONDING
>>
>>
>> Hi Craig,
>>
>> We are running Service Pack 6a on our server.
>>
>> I have been testing all my pages on my computer but when I transferred
>the
>> pages to the Server they don't respond. I changed the ODBC and nothing
>> happened.
>>
>> I included code from one page of my asp app. I would appreciate it if
>> someone might be able to help me out with some pointers on coding.
>>
>> <%
>> Dim objRS, strcompanyname, results, record, total, strproducts
>>
>> Dim strDSN
>> strDSN = "DSN=WO_BE;UID=sa;PWD=pwd"
>>
>>
>>
>> Set objRS = Server.CreateObject ("ADODB.Recordset")
>> objRS.Open "tblWorkOrders", strDSN, adOpenStatic, adLockOptimistic,
>> adCmdTable
>>
>> strproducts = request.form("txtproduct")
>> Response.Write "<table width='520' border='1' align='center'
>> bgcolor='lightblue'><tr><td colspan='3'>"
>>
>>
>> Response.Write "<table width='520' border='1' align='center'
>> bgcolor='lightblue'><tr><td align='left' width='1%' height='1%'><img
>> src='workorderlogo.jpg'></td><td align='center' colspan='2'><font
>> face='Verdana'><div class='fixedfont2'>Work Order
>> Search</td></tr></table></td></tr>"
>> Response.Write "<tr><td colspan='4'><br><font face='Verdana'><div
>> class='fixedfont'><b><center>Search Results</b><br><br>"
>>
>> Response.Write "<font face='Verdana'><div class='fixedfont'>You searched
>> for "<b>" & strproducts & "</b>"</center><br></td></tr>"
>> Response.Write "<tr><td bgcolor='white' align='center'><font
>> face='Verdana'><div class='fixedfont'><b>WO. #</td><td align='center'
>> bgcolor='white'><font face='Verdana'><div class='fixedfont'><b>Company
>> Name</td><td align='center' bgcolor='white'><font face='Verdana'><div
>> class='fixedfont'><b>Products</td></tr>"
>>
>> record = 0
>>
>> results = "productssamples LIKE '" & "*" & strproducts & "*'"
>> objRS.Filter = results
>> objRS.Find results
>> If Not objRS.EOF Then
>> While Not objRS.EOF
>> record = record + 1
>> Response.write "<tr><td align='center'
>> bgcolor='white'><font face='Verdana'><div class='fixedfont'><a
>> href=searchresults.asp?WO=" & objRS("Work_Order_No") & ">" & objRS
>> ("Work_Order_No") & "</a>"
>> Response.Write "</td><td bgcolor='white'><font
>> face='Verdana'><div class='fixedfont'>"
>> Response.write objRS("companyname") & "</td><td
>> bgcolor='white'><font face='Verdana'><div class='fixedfont'>"
>> Response.write objRS("productssamples")
>> & "</td></tr>"
>>
>> objRS.MoveNext
>> wend
>> Else
>> Response.Write "<br><tr><td colspan='3'
>> align='center' valign='middle' bgcolor='white'><br><font
>> face='Verdana'><div class='fixedfont'>Your Search Produced
>> "<b>0</b>" Results<br>"
>> End If
>>
>> Response.Write "<br></table>"
>>
>> total = record
>> response.write "<br><center><div class='fixedfont'><font
>> face='Verdana'>Your Search Returned <b>" & total & "</b> Records"
>>
>> objRS.Close
>>
>> Set objRS = Nothing
>>
>> %>
>>
>> > Are you closing all connections you make to your databases?
>> >
>> > Check that your code is not getting into a loop. Can you test to see if
>> any
>> > particular pages cause the instability?
>> >
>> > What SP are you on for NT?
>> >
>> > -----Original Message-----
>> > From: Jon Patterson [mailto:jon.patterson@s...]
>> > Sent: Tuesday 13 November 2001 15:08
>> > To: ASP Databases
>> > Subject: [asp_databases] ASP NOT RESPONDING
>> >
>> >
>> > i thought this would happen with pre mdac 2.0 but our NT server is
>> running
>> > MDAC 2.6 so it shouldn't have this ODBC memory leak anymore, right?
>> >
>> > the computer was just restarted yesterday and it is now not responding.
>> > it used to take at least 2 weeks or more before this would happen.
>> >
>> > maybe it's my open statements in asp.
>> >
>> > if anyone can help much thanks is appreciated.
>> >
>> > -jon
>> >
>ckf@k...
>> > $subst('Email.Unsub')
>> >
>> >
>> > _____________________________________________________________________
>> > This message has been checked for all known viruses by Star Internet
>> > delivered through the MessageLabs Virus Scanning Service. For further
>> > information visit http://www.star.net.uk/stats.asp or alternatively
>call
>> > Star Internet for details on the Virus Scanning Service.
>> >
>>
>>
>> $subst('Email.Unsub')
>>
>>
>> _____________________________________________________________________
>> This message has been checked for all known viruses by Star Internet
>> delivered through the MessageLabs Virus Scanning Service. For further
>> information visit http://www.star.net.uk/stats.asp or alternatively call
>> Star Internet for details on the Virus Scanning Service.
>>
>
>
>
>
Message #8 by "Jon Patterson" <jon.patterson@s...> on Wed, 14 Nov 2001 18:56:27
|
|
what should i do to make my asp apps start working again?
do i have to restart the server? i can do that during the day because it
is our PDC and everything is running on it.
Message #9 by "Craig Flannigan" <ckf@k...> on Thu, 15 Nov 2001 08:14:27 -0000
|
|
You could try stopping and restarting the WWW Service.
This wouldn't affect the rest of the server.
-----Original Message-----
From: Jon Patterson [mailto:jon.patterson@s...]
Sent: Wednesday 14 November 2001 18:56
To: ASP Databases
Subject: [asp_databases] ASP NOT RESPONDING
what should i do to make my asp apps start working again?
do i have to restart the server? i can do that during the day because it
is our PDC and everything is running on it.
$subst('Email.Unsub')
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service. For further
information visit http://www.star.net.uk/stats.asp or alternatively call
Star Internet for details on the Virus Scanning Service.
Message #10 by "Craig Flannigan" <ckf@k...> on Wed, 14 Nov 2001 15:06:30 -0000
|
|
Is it a clean installation of IIS 4?
-----Original Message-----
From: Jon Patterson [mailto:jon.patterson@s...]
Sent: Wednesday 14 November 2001 13:59
To: ASP Databases
Subject: [asp_databases] RE: ASP NOT RESPONDING
The simple asp pages don't respond either.
> Hi,
>
> Does it work properly on your computer?
>
> Do simple ASP pages cause the server to not respond, or is it only
happening
> when you use pages that contain database connections?
>
>
> Regards,
> Craig.
>
> -----Original Message-----
> From: Jon Patterson [mailto:jon.patterson@s...]
> Sent: Tuesday 13 November 2001 15:40
> To: ASP Databases
> Subject: [asp_databases] RE: ASP NOT RESPONDING
>
>
> Hi Craig,
>
> We are running Service Pack 6a on our server.
>
> I have been testing all my pages on my computer but when I transferred
the
> pages to the Server they don't respond. I changed the ODBC and nothing
> happened.
>
> I included code from one page of my asp app. I would appreciate it if
> someone might be able to help me out with some pointers on coding.
>
> <%
> Dim objRS, strcompanyname, results, record, total, strproducts
>
> Dim strDSN
> strDSN = "DSN=WO_BE;UID=sa;PWD=pwd"
>
>
>
> Set objRS = Server.CreateObject ("ADODB.Recordset")
> objRS.Open "tblWorkOrders", strDSN, adOpenStatic, adLockOptimistic,
> adCmdTable
>
> strproducts = request.form("txtproduct")
> Response.Write "<table width='520' border='1' align='center'
> bgcolor='lightblue'><tr><td colspan='3'>"
>
>
> Response.Write "<table width='520' border='1' align='center'
> bgcolor='lightblue'><tr><td align='left' width='1%' height='1%'><img
> src='workorderlogo.jpg'></td><td align='center' colspan='2'><font
> face='Verdana'><div class='fixedfont2'>Work Order
> Search</td></tr></table></td></tr>"
> Response.Write "<tr><td colspan='4'><br><font face='Verdana'><div
> class='fixedfont'><b><center>Search Results</b><br><br>"
>
> Response.Write "<font face='Verdana'><div class='fixedfont'>You searched
> for "<b>" & strproducts & "</b>"</center><br></td></tr>"
> Response.Write "<tr><td bgcolor='white' align='center'><font
> face='Verdana'><div class='fixedfont'><b>WO. #</td><td align='center'
> bgcolor='white'><font face='Verdana'><div class='fixedfont'><b>Company
> Name</td><td align='center' bgcolor='white'><font face='Verdana'><div
> class='fixedfont'><b>Products</td></tr>"
>
> record = 0
>
> results = "productssamples LIKE '" & "*" & strproducts & "*'"
> objRS.Filter = results
> objRS.Find results
> If Not objRS.EOF Then
> While Not objRS.EOF
> record = record + 1
> Response.write "<tr><td align='center'
> bgcolor='white'><font face='Verdana'><div class='fixedfont'><a
> href=searchresults.asp?WO=" & objRS("Work_Order_No") & ">" & objRS
> ("Work_Order_No") & "</a>"
> Response.Write "</td><td bgcolor='white'><font
> face='Verdana'><div class='fixedfont'>"
> Response.write objRS("companyname") & "</td><td
> bgcolor='white'><font face='Verdana'><div class='fixedfont'>"
> Response.write objRS("productssamples")
> & "</td></tr>"
>
> objRS.MoveNext
> wend
> Else
> Response.Write "<br><tr><td colspan='3'
> align='center' valign='middle' bgcolor='white'><br><font
> face='Verdana'><div class='fixedfont'>Your Search Produced
> "<b>0</b>" Results<br>"
> End If
>
> Response.Write "<br></table>"
>
> total = record
> response.write "<br><center><div class='fixedfont'><font
> face='Verdana'>Your Search Returned <b>" & total & "</b> Records"
>
> objRS.Close
>
> Set objRS = Nothing
>
> %>
>
> > Are you closing all connections you make to your databases?
> >
> > Check that your code is not getting into a loop. Can you test to see if
> any
> > particular pages cause the instability?
> >
> > What SP are you on for NT?
> >
> > -----Original Message-----
> > From: Jon Patterson [mailto:jon.patterson@s...]
> > Sent: Tuesday 13 November 2001 15:08
> > To: ASP Databases
> > Subject: [asp_databases] ASP NOT RESPONDING
> >
> >
> > i thought this would happen with pre mdac 2.0 but our NT server is
> running
> > MDAC 2.6 so it shouldn't have this ODBC memory leak anymore, right?
> >
> > the computer was just restarted yesterday and it is now not responding.
> > it used to take at least 2 weeks or more before this would happen.
> >
> > maybe it's my open statements in asp.
> >
> > if anyone can help much thanks is appreciated.
> >
> > -jon
> >
ckf@k...
> > $subst('Email.Unsub')
> >
> >
> > _____________________________________________________________________
> > This message has been checked for all known viruses by Star Internet
> > delivered through the MessageLabs Virus Scanning Service. For further
> > information visit http://www.star.net.uk/stats.asp or alternatively
call
> > Star Internet for details on the Virus Scanning Service.
> >
>
>
> $subst('Email.Unsub')
>
>
> _____________________________________________________________________
> This message has been checked for all known viruses by Star Internet
> delivered through the MessageLabs Virus Scanning Service. For further
> information visit http://www.star.net.uk/stats.asp or alternatively call
> Star Internet for details on the Virus Scanning Service.
>
$subst('Email.Unsub')
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service. For further
information visit http://www.star.net.uk/stats.asp or alternatively call
Star Internet for details on the Virus Scanning Service.
|
|
|
View Cart
