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 ??? 0 2049 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
|
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,
|
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...
|
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...
|
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);
| |
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...
|
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
|
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...
|
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...
|
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...
|
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,...
| |
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...
|
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,...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |