By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,246 Members | 1,480 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,246 IT Pros & Developers. It's quick & easy.

Query exceeds specified time limit or storage limit

P: 11
I am making a webpage that gets his information from an as400 system.

Now I seemed to hit some weird problem.

I have for example this select:
select field1,field2 from table

this is over 25.000 results. and works perfectly

now the second I add a where clause
select field1,field2 from table where field1 = 'test'

I get SQL query exceeds specified time limit or storage limit.
How can the same statement with a limitation have problems on storage or time, since it should have less results.

Hope someone can help me out here.

Thx in advance
Jul 9 '08 #1
Share this Question
Share on Google+
1 Reply

P: 11
Ok, I used QueryTimeOut=0;
in my connectionstring and this made it work
Jul 9 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.