| Author |
 Topic Search  Topic Options
|
Cool_Man 
Mod Builder Group
Joined: 23 March 2003
Location: Kuwait
Status: Offline
Points: 147
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Could you plz help me -boRg- ?
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
|
 |
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
zadax
Mod Builder Group
Joined: 19 January 2003
Location: Israel
Status: Offline
Points: 433
|
Post Options
Thanks(0)
Quote Reply
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
like
Server.ScriptTimeout = 90
Session.Timeout = 20
changin the number ..
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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
|
|
klr3
Groupie
Joined: 20 February 2003
Status: Offline
Points: 103
|
Post Options
Thanks(0)
Quote Reply
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=10 211 for more.... If anyone has a solution, plz let us know!!!! 
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
