RE: ADO/ASP timeout issue

From: v-kevy@xxxxxxxxxxxxxxxxxxxx (Kevin Yu [MSFT])
Date: Fri, 27 Jan 2006 08:47:38 GMT

Hi Subrata,

There are 2 places that you can check. The first is the ConnectionTimeout
property in the connection object. Since you have set the connection to
300, you can also check the CommandTimeout property of the SELECT command.
Please also enlarge it to 300. Please check the following link for more
information:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemdataoledboledbcommandclasscommandtimeouttopic.asp

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

.

References:
- ADO/ASP timeout issue
  - From: Subrata

Prev by Date: ADO/ASP timeout issue
Next by Date: Q: DataSets and SQL Server
Previous by thread: ADO/ASP timeout issue
Next by thread: Re: ADO/ASP timeout issue
Index(es):
- Date
- Thread

Relevant Pages

Re: timeout error
... You can set the CommandTimeout property of the ADO Command or Connection
... depending on which you are using to execute the query. ... (microsoft.public.sqlserver.server)
Re: ODBC Time Out Expired
... you may try to increase the value of the CommandTimeout property of the ADO
... connection object you use to execute your query. ... (microsoft.public.vb.general.discussion)
Re: timeout
... With ADO there is ... the CommandTimeout property on the connection
or a command object ... (microsoft.public.sqlserver.programming)
Re: ODBC/OLE DB Connection Pool
... > connection be kept open for the application as this will serialize all ...
threads ONCE they are returned to the pool. ... > Tips for ADO Users ...
> The ADO Connection object implicitly uses IDataInitialize. ... (microsoft.public.data.ado)
Re: ODBC/OLE DB Connection Pool
... > connection be kept open for the application as this will serialize all ...
threads ONCE they are returned to the pool. ... > Tips for ADO Users ...
> The ADO Connection object implicitly uses IDataInitialize. ... (microsoft.public.inetserver.asp.db)