473,322 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Close RS... "DLLHOST.EXE"

Hello Group,

I have had an issue on my server for a long time and what ever I have tryed
I just cant fix it.

I run mySQL and IIS, and my server will crash every few days because a file
on the server called DLLHOST.EXE has taken all the memory, and the mySQL
goes off line.

I close all of the record sets, and all of the Text files I read, as below

========
set fso = createobject("scripting.filesystemobject")
set act = fso.opentextfile(server.mappath ("/counters/year_count-"&
year(date())&".txt"))
countery = clng(act.readline)
countery = countery + 1
act.close
fso.close
========
============
strQuery = "SELECT * FROM category WHERE CATEGORY_ID='"&top_id&"';"
Set rscateinfo = adoConn.Execute(strQuery)

Do While Not rscateinfo.EOF

leveltop=rscateinfo("name").Value
leveltopurl=rscateinfo("link_url").Value

rscateinfo.MoveNext
loop
rscateinfo.close
set rscateinfo = Nothing
=============

each page I open the DLLHOST.EXE will will grow anything upto 150K per
page.. in the SQL example above the table for category has 35 columns, would
it make any differnace to memory if I selected the fields rather than all of
the fields from the in SELECT * FROM

The only solution I can come up with now is to buy more memory, but I am
sure I must be doing someting wrong.

Do I have to close the varables I have opened to stop this memory leek ????

Kind Regards

Graham Mattingley

Jul 19 '05 #1
3 3141
Make sure you close all the objects you are opening, dllhost.exe is nothing
but the one which actually runs your asp. so there should be something wrong
in the asp code thats causing load on that file.

"Graham Mattingley" <gr****@technocom.com> wrote in message
news:bh*******************@news.demon.co.uk...
Hello Group,

I have had an issue on my server for a long time and what ever I have tryed I just cant fix it.

I run mySQL and IIS, and my server will crash every few days because a file on the server called DLLHOST.EXE has taken all the memory, and the mySQL
goes off line.

I close all of the record sets, and all of the Text files I read, as below

========
set fso = createobject("scripting.filesystemobject")
set act = fso.opentextfile(server.mappath ("/counters/year_count-"&
year(date())&".txt"))
countery = clng(act.readline)
countery = countery + 1
act.close
fso.close
========
============
strQuery = "SELECT * FROM category WHERE CATEGORY_ID='"&top_id&"';"
Set rscateinfo = adoConn.Execute(strQuery)

Do While Not rscateinfo.EOF

leveltop=rscateinfo("name").Value
leveltopurl=rscateinfo("link_url").Value

rscateinfo.MoveNext
loop
rscateinfo.close
set rscateinfo = Nothing
=============

each page I open the DLLHOST.EXE will will grow anything upto 150K per
page.. in the SQL example above the table for category has 35 columns, would it make any differnace to memory if I selected the fields rather than all of the fields from the in SELECT * FROM

The only solution I can come up with now is to buy more memory, but I am
sure I must be doing someting wrong.

Do I have to close the varables I have opened to stop this memory leek ????
Kind Regards

Graham Mattingley

Jul 19 '05 #2
I don't see any code to close and destroy your connections. That needs to be
done as well.

Bob Barrows
Graham Mattingley wrote:
Hello Group,

I have had an issue on my server for a long time and what ever I have
tryed I just cant fix it.

I run mySQL and IIS, and my server will crash every few days because
a file on the server called DLLHOST.EXE has taken all the memory, and
the mySQL goes off line.

I close all of the record sets, and all of the Text files I read, as
below

========
set fso = createobject("scripting.filesystemobject")
set act = fso.opentextfile(server.mappath ("/counters/year_count-"&
year(date())&".txt"))
countery = clng(act.readline)
countery = countery + 1
act.close
fso.close
========
============
strQuery = "SELECT * FROM category WHERE CATEGORY_ID='"&top_id&"';"
Set rscateinfo = adoConn.Execute(strQuery)

Do While Not rscateinfo.EOF

leveltop=rscateinfo("name").Value
leveltopurl=rscateinfo("link_url").Value

rscateinfo.MoveNext
loop
rscateinfo.close
set rscateinfo = Nothing
=============

each page I open the DLLHOST.EXE will will grow anything upto 150K per
page.. in the SQL example above the table for category has 35
columns, would it make any differnace to memory if I selected the
fields rather than all of the fields from the in SELECT * FROM

The only solution I can come up with now is to buy more memory, but I
am sure I must be doing someting wrong.

Do I have to close the varables I have opened to stop this memory
leek ????

Kind Regards

Graham Mattingley

Jul 19 '05 #3
Thanks for that reply.....

I have a few 100 ASP pages on my server, is the DLLHOST.EXE file supposed to
grow in size at all, I have closed all of the objects and connections, and
when I refresh the same page 10 times, the file will grow by a 125K per
refresh

is the ASP complied page cached in the DLLHOST.EXE file ??

Kind Regards

Graham Mattingley


"vivek" <vi********@yahoo.com> wrote in message
news:e5**************@TK2MSFTNGP12.phx.gbl...
Make sure you close all the objects you are opening, dllhost.exe is nothing but the one which actually runs your asp. so there should be something wrong in the asp code thats causing load on that file.

"Graham Mattingley" <gr****@technocom.com> wrote in message
news:bh*******************@news.demon.co.uk...
Hello Group,

I have had an issue on my server for a long time and what ever I have tryed
I just cant fix it.

I run mySQL and IIS, and my server will crash every few days because a

file
on the server called DLLHOST.EXE has taken all the memory, and the mySQL
goes off line.

I close all of the record sets, and all of the Text files I read, as below
========
set fso = createobject("scripting.filesystemobject")
set act = fso.opentextfile(server.mappath ("/counters/year_count-"&
year(date())&".txt"))
countery = clng(act.readline)
countery = countery + 1
act.close
fso.close
========
============
strQuery = "SELECT * FROM category WHERE CATEGORY_ID='"&top_id&"';"
Set rscateinfo = adoConn.Execute(strQuery)

Do While Not rscateinfo.EOF

leveltop=rscateinfo("name").Value
leveltopurl=rscateinfo("link_url").Value

rscateinfo.MoveNext
loop
rscateinfo.close
set rscateinfo = Nothing
=============

each page I open the DLLHOST.EXE will will grow anything upto 150K per
page.. in the SQL example above the table for category has 35 columns,

would
it make any differnace to memory if I selected the fields rather than

all of
the fields from the in SELECT * FROM

The only solution I can come up with now is to buy more memory, but I am
sure I must be doing someting wrong.

Do I have to close the varables I have opened to stop this memory leek

????

Kind Regards

Graham Mattingley


Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: marco | last post by:
Hi, first of all ; sorry for my poor english ; i'm french ... and i hope you can understand below I use python (and wxpython) on a win32 platform, to build a simple "home theater pc". I want...
10
by: Vilmar Brazão de Oliveira | last post by:
HI people, what is wrong in the code bellow to kill iexplore.exe process after processing my page?? '»»Before comes routines to access data base and to send email. Set objWshell =...
0
by: uballing | last post by:
I am writing a "Windows Update" type application where via Web Services the client checks with the Server if he needs to download a newer version of a set of DLLs and EXE. If there is a newer...
2
by: Marek | last post by:
Actually, the very first question I should ask is "does it make sense at all?". For 2 days I've been trying to generate C# classes using XML schema and xsd.exe tool. So far the results are not...
3
by: Wardeaux | last post by:
All, I've written a "setup" wrapper that calls a sequence of "setup.exe", and all works except when I call the setup.exe for the MSDE, then it gets about half way through and then hangs... The...
3
by: bwalke | last post by:
I was wondering how the Process.Start() command can be used in a VB.NET Web Application. I have used this command in a Windows Application before successfully. I want the client side to envoke the...
3
by: Dean Slindee | last post by:
The code below is being used to launch WinWord.exe from a VB.NET program. Word launches, but displays this error message: "Word has experienced an error trying to open the file. Try these...
2
by: Anthony | last post by:
Hello All, Thanks for your help first, I wonder is there any link to sample or documentation that explain how to make .exe in C++ communicate to .exe in C#? I know there is some way like Share...
2
by: muttu2244 | last post by:
hi all i tried running a exe file info.exe from the spawnle cmd, its running fine from the interactive mode, but when i try to run the same info.exe file from a python file, its giving me the...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.