|
 |
asp_databases thread: ASP, Visual FoxPro, ISAPI
Message #1 by "Marek Jelinek" <marek@i...> on Fri, 21 Sep 2001 18:41:30
|
|
Hello,
my webhosting provider still abuse that I am crashing their servers.
He is always writing:
"Either your site is experiencing unusually high traffic or more frequently
you are not closing your connection strings = 0. Please review your code."
or
"... your site causing high ISAPI connections to raise extrememly high on
the server which will
ultimately cause the server to crash."
It is true that when our server has crashed last time, there was 200
active sessions (is it too much ?!)
We are using ASP with free tables in Visual FoxPro via ODBC.
---
At the beginning of each script we are using (or it is in file included):
DataConn_ConnectionString="DSN=mydsn;PASSWORD=;UID=;"
SET objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionTimeout = 15
objConn.CommandTimeout = 30
objConn.Open DataConn_ConnectionString
SET objComm = Server.CreateObject("ADODB.Command")
objComm.CommandType = 1
SET objComm.ActiveConnection = objConn
---
Inside the script I am using recordsets by this way:
objComm.CommandText = "SELECT * FROM mydbf"
rsTable.Open objComm, , 1, 1
---
And at the end of each script I am closing all used recordsets:
rsTable.Close
SET rsTable = Nothing
SET objConn = Nothing
SET objComm = Nothing
What am I doing wrong ?
Is it possible that connections are not closed properly by my commands ?
Sometimes the application is going down and then writes following error
messages:
error 'ASP 0115'
Unexpected error
A trappable error occurred in an external object. The script cannot
continue running.
or the server looks unavailable
Thank you for whatever ideas
Marek
Message #2 by "Joe Sabado" <joe.sabado@g...> on Fri, 21 Sep 2001 15:15:13 -0700
|
|
how many records are being returned in the recordset?
-----Original Message-----
From: Marek Jelinek <marek@i...>
To: ASP Databases <asp_databases@p...>
Date: Friday, September 21, 2001 10:50 AM
Subject: [asp_databases] ASP, Visual FoxPro, ISAPI
>Hello,
>my webhosting provider still abuse that I am crashing their servers.
>He is always writing:
>"Either your site is experiencing unusually high traffic or more frequently
>you are not closing your connection strings = 0. Please review your code."
>or
>"... your site causing high ISAPI connections to raise extrememly high on
>the server which will
>ultimately cause the server to crash."
>
>It is true that when our server has crashed last time, there was 200
>active sessions (is it too much ?!)
>
>We are using ASP with free tables in Visual FoxPro via ODBC.
>---
>At the beginning of each script we are using (or it is in file included):
> DataConn_ConnectionString="DSN=mydsn;PASSWORD=;UID=;"
> SET objConn = Server.CreateObject("ADODB.Connection")
> objConn.ConnectionTimeout = 15
> objConn.CommandTimeout = 30
> objConn.Open DataConn_ConnectionString
> SET objComm = Server.CreateObject("ADODB.Command")
> objComm.CommandType = 1
> SET objComm.ActiveConnection = objConn
>---
>Inside the script I am using recordsets by this way:
> objComm.CommandText = "SELECT * FROM mydbf"
> rsTable.Open objComm, , 1, 1
>---
>And at the end of each script I am closing all used recordsets:
> rsTable.Close
> SET rsTable = Nothing
> SET objConn = Nothing
> SET objComm = Nothing
>
>What am I doing wrong ?
>Is it possible that connections are not closed properly by my commands ?
>Sometimes the application is going down and then writes following error
>messages:
> error 'ASP 0115'
> Unexpected error
> A trappable error occurred in an external object. The script cannot
>continue running.
>
>or the server looks unavailable
>
>Thank you for whatever ideas
>Marek
Message #3 by David Cameron <dcameron@i...> on Mon, 24 Sep 2001 09:36:20 +1000
|
|
How about closing the connection as well as setting it to nothing.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: Joe Sabado [mailto:joe.sabado@g...]
Sent: Saturday, 22 September 2001 8:15 AM
To: ASP Databases
Subject: [asp_databases] Re: ASP, Visual FoxPro, ISAPI
how many records are being returned in the recordset?
-----Original Message-----
From: Marek Jelinek <marek@i...>
To: ASP Databases <asp_databases@p...>
Date: Friday, September 21, 2001 10:50 AM
Subject: [asp_databases] ASP, Visual FoxPro, ISAPI
>Hello,
>my webhosting provider still abuse that I am crashing their servers.
>He is always writing:
>"Either your site is experiencing unusually high traffic or more frequently
>you are not closing your connection strings = 0. Please review your code."
>or
>"... your site causing high ISAPI connections to raise extrememly high on
>the server which will
>ultimately cause the server to crash."
>
>It is true that when our server has crashed last time, there was 200
>active sessions (is it too much ?!)
>
>We are using ASP with free tables in Visual FoxPro via ODBC.
>---
>At the beginning of each script we are using (or it is in file included):
> DataConn_ConnectionString="DSN=mydsn;PASSWORD=;UID=;"
> SET objConn = Server.CreateObject("ADODB.Connection")
> objConn.ConnectionTimeout = 15
> objConn.CommandTimeout = 30
> objConn.Open DataConn_ConnectionString
> SET objComm = Server.CreateObject("ADODB.Command")
> objComm.CommandType = 1
> SET objComm.ActiveConnection = objConn
>---
>Inside the script I am using recordsets by this way:
> objComm.CommandText = "SELECT * FROM mydbf"
> rsTable.Open objComm, , 1, 1
>---
>And at the end of each script I am closing all used recordsets:
> rsTable.Close
> SET rsTable = Nothing
> SET objConn = Nothing
> SET objComm = Nothing
>
>What am I doing wrong ?
>Is it possible that connections are not closed properly by my commands ?
>Sometimes the application is going down and then writes following error
>messages:
> error 'ASP 0115'
> Unexpected error
> A trappable error occurred in an external object. The script cannot
>continue running.
>
>or the server looks unavailable
>
>Thank you for whatever ideas
>Marek
|
|
|
View Cart
