ASP query timeout solution

xiaoxiao2021-03-06  81

I am using SQL Server as a full-text search, found that the ASP query page often occurs because the Squarios table is increasing, the ODBC Driver: Timeout Expired error will occur frequently. Query the Google and Test For a long time, finally resolved, now summarize the following: 1 Add the following, pay attention to all settings, only one test is not: <% server.scripttimeout = 360%> 1) Add timeout settings in the database connection string, such as "... CONNECT TIMEOUT = 0 "2) CommandTimeout Properties of Connection Objects: Con.commandTimeout = 3603) CommandTimeout Property of Command Object: Command Object does not inherit the concept of Connection, so you have to timeout. Set the commandtimeout attribute separately. Finally, if this is not, it may be a browser settings: 1. HKEY_CURRENT_USER / SOFTWARE / Microsoft / Windows / CurrentVersion / Internet Settings in the registry with a DWORD Type ReceTimeout, value set For example, 8 9. 2. Restart Computer.Notes: Many people like to use "On Error Resume next ... if err.number <> 0 handle ELSE ...." Show the page error, so it will not There is no preference for the database out of the information. When you debug, you can view the error message by output error description and code: Err.Description, Err.Number, Err.Source, etc.

Description: This problem solves the list of many online information, and cannot be listed one by one. If there is similarity, it should be normal.

转载请注明原文地址:https://www.9cbs.com/read-121418.html

New Post(0)