Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-11 : 08:24:51
|
Deepak writes "Hello There,
I am Deepak. I am Developing a Search Engine for Finding Business Records,Locations,Products,Categories.
For that i wrote a Query. I am Using SQL Server as Back-End and ASP.
I have a Problem for Getting Results from SQL Query.
I already created Non-Clustered Index on My Main Table
While Running a Large SQL Query from ASP which Sometimes gives an Error saying that TimeOut Expired Or sometimes Executes the query and i get the results.
The actual Problem is that the Sql Server sometimes takes much time to Execute that query and so the ASP returns the error saying that
***********ERROR*********************
Microsoft OLE DB Provider for ODBC Drivers
error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
***********ERROR*********************
Can anybody tell me How to handle this Error
Is there any Property in SQL or ASP that u can set so that query if takes much time should not return an Error and give the Required Results.
Note:I already created Non-Clustered Index on My Main Table" |
|
|
|
|
|
Running a large SQL query from ASP