DB memory problems

Hi

I am connecting to an Access DB but when trying to retrieve search results
from the DB, I am met with the error:

Error Type:
Response object, ASP 0100 (0x8007000E)
Unable to allocate required memory.
/sa143/chis/CHIS_View_Results.asp


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)

Page:
POST 40 bytes to /sa143/chis/CHIS_View_Results.asp

POST Data:
View_CHIS_Name=6&Display=Display+Results

I originally tried solving the above problem by making the DB table smaller
excluding the fields that I do not need to retrieve. This cut down the script
running time but obviously it has not solved the ultimate problem because i
still have the error.

I originally had timeout problems which I solved using the
Server.ScriptTimeout code.

Any suggestions on this would be appreciated.

Thanx

A-Face

Re: DB memory problems

A-Face wrote:
> Hi
>
> I am connecting to an Access DB but when trying to retrieve search
> results from the DB, I am met with the error:
>
> Error Type:
> Response object, ASP 0100 (0x8007000E)
> Unable to allocate required memory.
> /sa143/chis/CHIS_View_Results.asp
>
>
> Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
> 1.1.4322)
>
> Page:
> POST 40 bytes to /sa143/chis/CHIS_View_Results.asp
>
> POST Data:
> View_CHIS_Name=6&Display=Display+Results
>
> I originally tried solving the above problem by making the DB table
> smaller excluding the fields that I do not need to retrieve. This cut
> down the script running time but obviously it has not solved the
> ultimate problem because i still have the error.
>
> I originally had timeout problems which I solved using the
> Server.ScriptTimeout code.
>
> Any suggestions on this would be appreciated.
>
> Thanx
>
> A-Face

Does this help:
http://www.aspfaq.com/show.asp?id=2131

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"