Web Wiz Forums - Could you plz help me -boRg- ?

Print Page | Close Window

Could you plz help me -boRg- ?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11625
Printed Date: 09 April 2026 at 1:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Could you plz help me -boRg- ?

Posted By: Cool_Man
Subject: Could you plz help me -boRg- ?
Date Posted: 25 August 2004 at 7:38am

Hi -boRg-,

when i try to search for some of words by 'search_form.asp' page and chioce 'Message body' and pess on 'Start Search', i get the following error meassage in 'search.asp' page:

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

/forum/search.asp, line 356

Could you tell me what is the problem plz?

comment: My tblThread table in my MS SQL DataBase include: 178000 rows.

-------------

Thanks for all

Replies:

Posted By: ljamal
Date Posted: 25 August 2004 at 2:37pm

The search takes longer to return results than the page allows. You can increase the time for the page, remove records (so there are less to search through) or look to using MS SQL text searching.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: zadax
Date Posted: 25 August 2004 at 9:14pm

somone corect me if i am wrong but he can change the expire time at the common file

Server.ScriptTimeout = 90
Session.Timeout = 20

changin the number ..

Posted By: dj air
Date Posted: 26 August 2004 at 5:39am

that is correct zadax.
you can change those, but some hosts don't allow you to set your own.

mainly free hosts though.

Cool_Man you want to change the server.ScriptTimeout

Posted By: klr3
Date Posted: 26 August 2004 at 10:11am

I have same problem, and for a long time now, and DO NOT know what to do - the time-out this out is very high on my server, 180 i the common.asp file.

Please read http://forums.webwiz.net/forum_posts.asp?TID=10211 - http://forums.webwiz.net/forum_posts.asp?TID=10 211 for more....

If anyone has a solution, plz let us know!!!!

Posted By: ljamal
Date Posted: 26 August 2004 at 10:36am

Rather than changing it on the entire site by changing it in the common.asp, you may just want to change it by adding the server.scriptTimeout = xx to the search page below the common.asp include. This will increase the time out on that particular page and not for the entire site.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: dpyers
Date Posted: 26 August 2004 at 12:04pm

Although you can adjust the script timeout for all pages through the global.asa, remember that it is set at whatever value your host chose for a reason. It's also a real PITA to wait forever for a timeout when you're trying to troubleshoot, or if you're a user waiting for a response from a script that's going to fail anyway.

If you mess with the default value, it's usually better to do it on a script-by-script basis - only change in those scripte/pages where you really need to.

-------------

Lead me not into temptation... I know the short cut, follow me.