OLE-DB Resource Error

• ckempste

  SSCoach

  Points: 17983

  More actions

  May 28, 2002 at 2:41 am

  #101158

  Hi all

  We have a large com+ app connecting via ole-db sql-server provider to a sql2k sp2 box (per cpu licence), we are getting the following error:

  Error Code: -2147217871

  VB Error: Method '~' of object '~'

  0x80040E31 -2147217871 Execution aborted because a resource limit has

  been reached; no results have been returned

  The servers are under some load and some queries are large reports (report of the entire db type). Others are simple functions but experience this problem.

  Ideas??

  Cheers

  Chris.

  
  Chris Kempster
  www.chriskempster.com
  Author of "SQL Server Backup, Recovery & Troubleshooting"
  Author of "SQL Server 2k for the Oracle DBA"

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 28, 2002 at 5:23 am

  #429812

  I believe it is more of a timeout issue and could be related to blocking on the server. Check out the follwoing link for some information and try setting your query timeout a bit longer.

  http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=msall&Query=2147217871&Queryc=2147217871&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)