General information
Category:
Active Server Page
Hi,
It look that the SQL server take more time to search the data that before, check the indexes -it look like the search doesn't have index key- or why it take more time to get the information, do the same test using Server Query Analyzer.
What SQL version are you using?
Gerardo
>Hi! My script has been running for more than a month now and users have been accessing it everyday in our intranet. But yesterday, we encountered the ff. error:
>
>Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
>
>[Microsoft][ODBC SQL Server Driver]Timeout expired
>
>/eodcacdcc/agingneg.asp, line 152
>
>I am using a ADODB.Recordset.
>
>This line is:
>
>db_rs.open dbf_qry, "DSN=my_sql;UID=sa;PWD="
>
>where dbf_qry = "Select ..."
>
>This has been working for more than a month everyday. What happened. Can anyone give me some pointers on this? I would really appreciate the help since a lot of ppl. are now unable
>to access this particular asp page.
>
>Thanks
>
>Ramon Carlos
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only