ADO/ASP timeout issue

From: "Subrata" <Subrata@xxxxxxxxxxxxxxxxx>
Date: Fri, 27 Jan 2006 11:56:00 +0530

In our .NET application, we are querying a Sybase database to retrieve
records that needs to be displayed on the screen. We have a sql which takes
more than 2 mins to run. When executing the same from aspx page, the
application does not wait till 2 mins. It waits exactly 60 secs and then
gives a "Timeout Exceeded" Error.

Checked out the site,
http://www.dotnetjunkies.com/Forums/ShowPost.aspx?PostID=8996 to solve this
issue. Tried changing the connection string but still it didn't help.

On dev environment it waits for 60 secs but the same application on staging
machine takes only 30secs to throw the error message above. Are there any
settings where we can increase the time out period from the .NET application
to the database?

.

Follow-Ups:
- Re: ADO/ASP timeout issue
  - From: Daniel Crichton
- RE: ADO/ASP timeout issue
  - From: Kevin Yu [MSFT]

Prev by Date: Re: VS.2005 c# Autonumber via Access with @@IDENTITY Failing
Next by Date: RE: ADO/ASP timeout issue
Previous by thread: Re: ADO Excel connection string reference documentation
Next by thread: RE: ADO/ASP timeout issue
Index(es):
- Date
- Thread

Relevant Pages

Re: Querying a DB and sending Email based on query output
... Wondering if there is an adapter for Sybase database, ... > Your going to
have to write your query and probably save it as a stored ... >>> You'll probably
want to use the SQL adapter, ... (microsoft.public.biztalk.general)
Re: Stored Procedure using perl
... > I am trying to execute a stored procedure in Sybase database using perl
... > DBI and I am getting the following error message. ... (perl.dbi.users)
Connecting to Database
... SYBASE database on a unix server. ... I would like to connect to another
database on a Microsoft SQL ... using Perl from my unix server. ... (perl.dbi.users)
MS SQL server & Sybase interoperability
... I have an application build on Sybase database, and we waant to install MS ...
SQL 2000 on the same machine for a different apppliction, ... (microsoft.public.sqlserver.server)