Error reported by COM object

• Prakash-205770

  Ten Centuries

  Points: 1079

  More actions

  April 20, 2006 at 6:35 am

  #167971

  Hi,

  The following error is returned by a COM object while executing a stored procedure.  This error is not reported always. Sometimes it works fine.

  0x80040e31 - Execution aborted because a resource limit has been reached; no results have been returned

  Can any one put lights on  it?

  Thanks

  R.Prakash

   

  ---

  Kindest Regards,

  R

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  April 20, 2006 at 12:05 pm

  #633338

  I haven't come across this myself but apparently a whole bunch of others have (google) - suggestions include increasing timeout to size of tempdb...read these 2 links to see if they help you any...

  link 1

  link 2

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• noeld

  SSC Guru

  Points: 96590

  More actions

  April 20, 2006 at 1:09 pm

  #633361

  Definitely you are leaking handles!

  Make sure that whatever is using the COM object is closing the handle. in case of sp_OA* you need to ensure that sp_OADestroy gets called ALLWAYS after you adquired a handle successfuly

   

  Don't know much about your app but without further details I can't help you more.

   

  Cheers,

   

  
  * Noel