473,834 Members | 1,828 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

This script causes NP Pool to exhaust itself - can't see why - very simple

Something changed recently on our W2K SP4 machine when we installed
INTERSOLV ODBC software... the following script just opens a connection
to an MS-Access DB, gets a record then tears down the connection

<%
tpl_ConnectStri ng = "DRIVER={Micros oft Access Driver (*.mdb)};
DBQ=g:/inetpub/wwwroot/servers/xta_db/tpl.mdb"
query = "select tpl_text from templates where tpl_name='showa rt_top'"
response.buffer =false
for i=1 to 100

on error resume next
set Conn = Server.CreateOb ject("ADODB.Con nection")
if (err.number <0 ) then
response.write "Error creating Connection in getrecordset,
number=" & err.description
end if
on error resume next
conn.open TPL_ConnectStri ng
if (err.number <0 ) then
response.write "Error opening Connection in getrecordset,
number=" & err.description
end if

on error resume next
Set rs = Server.CreateOb ject("ADODB.Rec ordset")
if (err.number <0 ) then
response.write "Error creating Recordset in getrecordset, number="
& err.description
end if

on error resume next
rs.open query,conn
if (err.number <0 ) then
response.write "Error executing query in
getrecordset(ge t_template), number=" & err.description
else
xxx=rs("tpl_tex t")
end if

response.write "loop=" + cstr(i)+"..size of
tpl="+cstr(len( xxx))+"<p>"

rs.close
if (err.number <0 ) then
response.write "Error closing Recordset in getrecordset, number=" &
err.description
end if

on error resume next
rs=nothing
if (err.number <0 ) then
response.write "Error setting to nothing Recordset in getrecordset,
number=" & err.description
end if

on error resume next
conn.close
if (err.number <0 ) then
response.write "Error closing conn in getrecordset, number=" &
err.description
end if

on error resume next
conn=nothing
if (err.number <0 ) then
response.write "Error setting conn to nothing in getrecordset,
number=" & err.description
end if
next
When we run this script now, we can see NP Pool climb in the
DLLHOST.EXE process until it hits about 1,000K , then we get 'system
resource exceeded'.... I've looked everywhere for a clue as to what's
changed , but can't find it... I know it has something to do with MDAC
and the Access driver, but another system we have that does not have
the INTERSOLV installed, does not run out of NP Pool..

My question is... what could possibly be exhausting NP Pool when an
Access db is connected to, retrieved from, followed by a close
recordset, set to nothing, close connection, set to nothing ???

Nov 13 '05 #1
0 2049

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

Similar topics

22
3075
by: Robert Brown | last post by:
suppose I have the following table: CREATE TABLE (int level, color varchar, length int, width int, height int) It has the following rows 1, "RED", 8, 10, 12 2, NULL, NULL, NULL, 20 3, NULL, 9, 82, 25
3
1938
by: John Black | last post by:
Hi, I have some code like this, itr = find_if(this->pool.begin(), this->pool.end(), bind2nd(mem_fun_ref(&Pool::isAvailable), make_pair(base, high))); But compiler always complains a lot STL template instantiation errors. My class definition is like this,
10
2758
by: Guadala Harry | last post by:
I have a modal dialog that currently does all of the following except item 4. 1. lets users select a graphic from a list of thumbnails (and when selected, displays the full-size image in a preview DIV) 2. when users close the dialog, the application receives the URL to the selected graphic. 3. the modal dialog lets the users upload a new graphic if the dialog does not present them with one they are already happy with. 4. upon uploading...
6
4908
by: scottyman | last post by:
I can't make this script work properly. I've gone as far as I can with it and the rest is out of my ability. I can do some html editing but I'm lost in the Java world. The script at the bottom of the html page controls the form fields that are required. It doesn't function like it's supposed to and I can leave all the fields blank and it still submits the form. Also I can't get it to transfer the file in the upload section. The file name...
0
1373
by: kiran kumar | last post by:
Hi All, I am working on embedded python on C these days. I feel there is a memory leakage in this code. I have used our own memory pool and all the python code will use the heap from this memory pool. RunScript(pScriptName,pFuncName,...) { PyEval_AcquireLock() threadState = Py_NewInterpreter(); PyThreadState_Swap(threadState);
2
1539
by: Greg Scharlemann | last post by:
The last time I tried to ask this question...Google Groups screwed up my message and there was no subject (sorry for that - I know it's annoying). I'm trying to learn how to develop a plug-in that allows users to display data from one site in a third party site, like Google Adwords or the Digg counter for news stories. I took a look at Digg.com and found the following: It looks like digg is doing the following to show the number of...
3
2280
by: Nalaka | last post by:
Hi, Can you tell me what type a things in asp.net code can crash... "application pool". Any example would do.... I was under imresiion that code cannot crash the app pool. Any direction is deeply appreciated Nalaka
1
559
by: Navin Mishra | last post by:
Hi, I've an ASP.NET web service that consumes other web services as well as sends data to client using TCP blocking sockets on a custom thread pool threads. If I use asynchronous sockets to send data to clients, would it use threads from ASP.NET IO thread pool ? Is it a good idea ? Or could it potentially exhaust all threads from IO thread pool and cause problems for web service to access other web services ? Thanks in advance and...
1
1653
by: DannyyBoyy | last post by:
My daughter has been swimming year round in Mt. Pleasant, SC and she swims at meets with different pool lengths - 100 meters (Long Course Meters or LCM), 50 yards (Short Course Yards or SCY) and 50 meters (Short Course Meters or SCM). I'd like to create an ASP page that has input forms to convert times for each pool length to determine how she does each swim. For example, if she swims 1 lap of freestyle in a 25-yard pool and does it in...
0
9799
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9649
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10515
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10554
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10224
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7761
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5799
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4428
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3985
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.