May 28, 2002 at 2:41 am
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"
May 28, 2002 at 5:23 am
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.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy