OLEDB error E_OUTOFMEMORY (0x8007000E)

[Shadow]

I have conducted a series of load tests on my newly developed system [ASP.NET(W2K SP3) + Sybase 12 DB(AIX)] and it constantly returned the following error in event log when it reacted a certain period of time. I believed it was something to do with the servers capacity. I have 8GB ram and 8 CPU. Did i missed some tuning on IIS or OS? Pls advise

Error received:

No error information available: E_OUTOFMEMORY(0x8007000E).
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: No error information available: E_OUTOFMEMORY(0x8007000E).


Thank you

Shadow

[frictionadd]

I had this for a while also. I'm only running an Athlon XP 2600+ with 1.5 gigs ram but I got it after a certain period of time. If you have SQL server (I'm guessing you do) it gives this error bcause you aren't properly closing your connections to the database. You must remember that you need to close both DataReaders and Connections As well. Also, it is good practice in your Command's for ASP.NET to pass it with the argument CommandBehavior.CloseConnection so that it is one less thing to worry about. If you look in Enterprise manager at all of the open connections to the server, you will understand. Took me a little while to discover the cause. One way to remedy it is to wait for the timeout on each process (very long time), restart the SQL server (if you are using Access MDB's or similar then you have SOL), or restart the server. Good luck,

[bruce]

How big is the query? Do you expect a large result set?

If you are using MS Access, how big is the database file?

[b]quote:Originally posted by Shadow

I have conducted a series of load tests on my newly developed system [ASP.NET(W2K SP3) + Sybase 12 DB(AIX)] and it constantly returned the following error in event log when it reacted a certain period of time. I believed it was something to do with the servers capacity. I have 8GB ram and 8 CPU. Did i missed some tuning on IIS or OS? Pls advise

Error received:

No error information available: E_OUTOFMEMORY(0x8007000E).
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: No error information available: E_OUTOFMEMORY(0x8007000E).


Thank you

Shadow
</blockquote id="quote"></font id="quote">

[mintu_singh]

Hi,

I am also getting this error and also I found the conection and command ojects are unclosed on most of my files. If I close all of them through out the code then it will take lot of time.

Is there any other way to remove all the unused objects from memory.

Thanks,

[bruce]

The application is responsible for closing the database connection. It is a common practice to close unnecessary database connection

[b]quote:Originally posted by mintu_singh

Hi,

I am also getting this error and also I found the conection and command ojects are unclosed on most of my files. If I close all of them through out the code then it will take lot of time.

Is there any other way to remove all the unused objects from memory.

Thanks,

</blockquote id="quote"></font id="quote">