Re: timeout

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 12/12/04 

Date: Sun, 12 Dec 2004 21:14:51 -0000

Hi

You don't say how you are accessing SQL Server through VB. With ADO there is
the CommandTimeout property on the connection or a command object
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprocommandtimeout.asp.
It is somewhat puzzling to know why you are doing this through code and not
as either part of a maintainance plan or other backend process?

John

"Frank Dulk" <fdulk@bol.com.br> wrote in message
news:e8KAz4I4EHA.1524@TK2MSFTNGP09.phx.gbl...
> Hello, I am with the following problem:
>
> Use vb6 with sqlserver 7 and the time limits to give timeout mistake it is
> very small. I need to create a big index or a consultation that it is long
> a
> little more, and soon I receive timeout. What can make to administer this
> time?
>
> Or which is the improvement solution?
>
>

Relevant Pages

  • Re: VBscript Timed out
    ... create a Command object and set the CommandTimeout property. ... Set connection = CreateObject ...
    (microsoft.public.sqlserver.programming)
  • 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: ADO/ASP timeout issue
    ... property in the connection object. ... Since you have set the connection to ... you can also check the CommandTimeout property of the SELECT command. ... Prev by Date: ...
    (microsoft.public.data.ado)
  • Re: ADO Properties
    ... ADO.NET has same objects like Connection, Command object as ADO does. ... there is Dataset in place of Recordset. ...
    (microsoft.public.dotnet.framework.adonet)