Asir
|
| Posted: 04/05/2004, 2:13 PM |
|
i have a huge database,, it takes 40-50 sec to get results on query analyzer..
i have grid report search page. i get
Error: [Microsoft][ODBC SQL Server Driver]Timeout expired (Microsoft OLE DB Provider for ODBC Drivers
how can i set connection or sql time out? i need to extend the time to get results
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 04/05/2004, 2:20 PM |
|
Take a look at http://groups.google.com/groups?q=vbscript%20odbc%20%22Timeout%20expired%22
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
chris
|
| Posted: 04/05/2004, 5:29 PM |
|
You may need to set the indexes correctly in the sql tables. I had the same problem when I started to use Code Charge Studio where I had a search function and a grid table to display the results.
Based on your search criterias, you need to set non-clustered indexes in the SQL table you are running the query from. Example: If one of your search criteria is Last Name, then you must create a non-clustered index on the Last Name field. You must set the indexes based on all your search criterias.
Good luck! 
|
|
|
|
|
