System resource exceeded

Yes that is correct. However there are several web apps running on the server
which access the same database, and I have no control over the one app, other
than to start and stop it. That's why I asked was there a way to just close
all open ODBC connections, or reset the ODBC connections without rebooting
the server so the down time would be just the reset time versus a 2-4min
reboot.

I will go through my code again however and look to see if connections are
closed properly.

"Kevin Yu [MSFT]" wrote:

> Hi Dave,
>
> First of all, I would like to confirm my understanding of your issue. From
> your description, I understand that you're receiving an "System resource
> exceeded." error after running a web program for about 4 days. If there is
> any misunderstanding, please feel free to let me know.
>
> This error might be caused by many reason. Sometimes a constantly opened
> connection to the database or an opened Recordset which consumes a lot of
> resources might generate this issue. Please try to go through your code to
> see if all the connections or recordsets are closed properly and the
> references to them have been set to Nothing after they become useless.
> Also, we can try to open the Recordset with less resource consuming cursor
> types. For example, open it with a dynamic cursor will be better.
>
> HTH.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>
>
 >> Stay informed about: System resource exceeded 

Hi Dave,

I think there is no way for us to reset a single ODBC connection to certain
data source other than restarting the whole application. Thanks for
checking the code. If there's anything unclear, please feel free to reply
to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 >> Stay informed about: System resource exceeded 

Hello there... I am experiencing the same problem. I have found that
when i receive this message (about every hour with the amount of
traffic) it is the inetinfo.exe that has crashed and will no longer
serve up any pages. I have been using IISRECYLE to look at the process
and if it gets over a certain memory limit it stops IIS and restarts it.
This allows my ODBC connections to resume as normal. What i have not
figured out is who the Non-pool memory on inetinfo.exe runs out of
control and crashed the process in the first place. If you have any
ideas.... I recently installed an Informix SDK to the server as well,
and updated to mdac2.8 for some history.

THansk

William

Kevin Yu [MSFT] wrote:
> *Hi Dave,
>
> I think there is no way for us to reset a single ODBC connection to
> certain
> data source other than restarting the whole application. Thanks for
> checking the code. If there's anything unclear, please feel free to
> reply
> to the post.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights." *



--
Uneditdwill
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------
 >> Stay informed about: System resource exceeded 

One thing you can do versus a reboot is to use taskmanager to find the
w3wp.exe process that is using inordinate amounts of RAM - kill that
process and the offending IIS instance will recover without destroying
other instances on the box.

Hope this helps!
Bill Dodd
mcsd, mcad, mcdba
me.DeleteThis@billdodd.net

Dave wrote:
> *Yes that is correct. However there are several web apps running on
> the server
> which access the same database, and I have no control over the one
> app, other
> than to start and stop it. That's why I asked was there a way to just
> close
> all open ODBC connections, or reset the ODBC connections without
> rebooting
> the server so the down time would be just the reset time versus a
> 2-4min
> reboot.
>
> I will go through my code again however and look to see if
> connections are
> closed properly.
>
> "Kevin Yu [MSFT]" wrote:
>
> > Hi Dave,
> >
> > First of all, I would like to confirm my understanding of your
> issue. From
> > your description, I understand that you're receiving an "System
> resource
> > exceeded." error after running a web program for about 4 days. If
> there is
> > any misunderstanding, please feel free to let me know.
> >
> > This error might be caused by many reason. Sometimes a constantly
> opened
> > connection to the database or an opened Recordset which consumes a
> lot of
> > resources might generate this issue. Please try to go through your
> code to
> > see if all the connections or recordsets are closed properly and
> the
> > references to them have been set to Nothing after they become
> useless.
> > Also, we can try to open the Recordset with less resource consuming
> cursor
> > types. For example, open it with a dynamic cursor will be better.
> >
> > HTH.
> >
> > Kevin Yu
> > =======
> > "This posting is provided "AS IS" with no warranties, and confers
> no
> > rights."
> >
> > *



--
bill
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------
 >> Stay informed about: System resource exceeded