Hi,
    Can anyone help me,
I have a datagrid that is bound to a SQL 2000 DB. When I
go to load my data in the datagrid I always get the following error:

Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.

Everytime I execute a select statement that takes longer than 20 seconds I
then get the error above.  Where do I go to
increase the default value for timeout.


Thanks in advance,

Ugo

In SQL Manager right-click on the server hit properties and click on
connections
In the query time-out field change the value


-----Original Message-----
From: Ugo Bachetti [mailto:ubachetti@h...]
Sent: Monday, March 25, 2002 4:44 PM
To: ASP+
Subject: [aspx] Timeout



Hi,
    Can anyone help me,
I have a datagrid that is bound to a SQL 2000 DB. When I
go to load my data in the datagrid I always get the following error:

Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.

Everytime I execute a select statement that takes longer than 20 seconds
I then get the error above.  Where do I go to increase the default value
for timeout.


Thanks in advance,

Ugo

IIS has an ASP page time out setting

RuSs

-----Original Message-----
From: Ugo Bachetti [mailto:ubachetti@h...]
Sent: Tuesday, 26 March 2002 8:44 AM
To: ASP+
Subject: [aspx] Timeout



Hi,
    Can anyone help me,
I have a datagrid that is bound to a SQL 2000 DB. When I
go to load my data in the datagrid I always get the following error:

Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.

Everytime I execute a select statement that takes longer than 20 seconds I
then get the error above.  Where do I go to
increase the default value for timeout.


Thanks in advance,

Ugo