Re: timeout error

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 08/10/04 

Date: Mon, 9 Aug 2004 21:53:19 -0500

You can set the CommandTimeout property of the ADO Command or Connection
object, depending on which you are using to execute the query. The default
is 30 seconds. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Mac Vazehgoo" <mahmood.vazehgoo@unisys.com> wrote in message
news:cf99f1$thi$1@si05.rsvl.unisys.com...
> When I run my application with a rather large database,  I get  'timeout
> expired' error.
> The SQL version is 2000 and all defaults are set for sp_configure
> parameters.
>
> I have no problem running via QueryAnalyzer (it takes a while).  But the
> application is the one that gets timed out.
> The application code does not set any timeout parameter.  It uses ADO for
> the connection and query.
>
> Any idea what I need to set in the application to behave like the QA ?
>
> TIA
> Mac
>
>

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. ... >> The application code does not set any timeout parameter. ...
    (microsoft.public.sqlserver.server)
  • Re: query time out
    ... then you would need to use CommandTimeout property of ... the Connection or Command object. ... ConnectionTimeout just established timeout ... for the time to open connection to the database, not to run query ...
    (microsoft.public.vb.database.ado)
  • Re: ASP - FROM statement slows down connection to database
    ... Open your database in Access, switch to the Queries tab, create a new query ... in Design View without choosing a table, swtich to SQL View, paste the sql ... connection string rather than using an ... recordset open statements. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Update checking
    ... My thought was to use a simple query with a "username" param ... concurrency exceptions happen if the data you queried has ... > was and basically let the user work in a similar offline mode. ... Where does connection pooling come ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access looks for .mdb rather than Progress schema
    ... # Same query previously worked in Progress 8.x using SQL89. ... This entry allows you to keep your existing code written with the ODBC ... BTW, if you put all of the connect information into the connect string, ... I also tried putting the whole thing in the connection string: ...
    (microsoft.public.access.modulesdaovba)