[ODBC_Microsoft_Access_Driver]_System_resource_exceeded

[Bob Barrows]

Eric wrote:

> I the the caption problem twice in 30 min. Anyone know
> what happen of my IIS ?

This must be related to a recent update of Windows, because we've just
started seeing a rash of related problems. I've seen no clear-cut solution
to this yet. You should try the following:

1. Try switching to the native Jet OLEDB provider instead of ODBC.
([url]www.connectionstrings.com[/url])
2. Make sure that you are explicitly closing and destroying all ADO objects
in all of your pages after you are finished using them. Failure to do so may
lead to memory leaks which may eventually cause the error.

HTH,
Bob Barrows

[Aaron Bertrand - MVP]

[url]http://www.aspfaq.com/2131[/url]
[url]http://www.aspfaq.com/2301[/url]


"Eric" <eric@hkb2b.com.hk> wrote in message
news:07f601c3687d$7fddaa20$a501280a@phx.gbl...

> I the the caption problem twice in 30 min. Anyone know
> what happen of my IIS ?