<div>
For a Connection:<br />
oConn.ConnectionTimeout = 30<br />
For a Command:<br />
oCmd.CommandTimeout = 30
</div>


For a Connection:
oConn.ConnectionTimeout = 30
For a Command:
oCmd.CommandTimeout = 30

<div>
I'm using ConnectionString<br />
and set <br />
oConn.ConnectionString=&quot;..<wbr />..&quot;<br />
oConn.ConnectionTimeout=90<wbr />0000000<br />
oConn.Open<br />
recordset=OConn.Execute(&quot;.<wbr />...&quot;)<br />
but I still receive Time out<br />
:(
</div>


I'm using ConnectionString
and set
oConn.ConnectionString="...."
oConn.ConnectionTimeout=900000000
oConn.Open
recordset=OConn.Execute("....")
but I still receive Time out
:(

<div>
Set the CommandTimeout not the ConnectionTimeout property. &nbsp;In other words:<br />
oConn.ConnectionString=&quot;..<wbr />..&quot;<br />
oConn.CommandTimeout = 0 &nbsp;'Infinite timeout<br />
oConn.Open<br />
recordset=OConn.Execute(&quot;.<wbr />...&quot;)<br />
<br />
Anthony<br />

</div>


Set the CommandTimeout not the ConnectionTimeout property.  In other words:
oConn.ConnectionString="...."
oConn.CommandTimeout = 0  'Infinite timeout
oConn.Open
recordset=OConn.Execute("....")

Anthony


<div>
If the stored procedure times out, you might first check how much time it needs to execute (using query analyser). If there it takes only seconds, then you need to check why the connection takes so much time, otherwise start optimizing the proc<br />
<br />
CHeers
</div>


If the stored procedure times out, you might first check how much time it needs to execute (using query analyser). If there it takes only seconds, then you need to check why the connection takes so much time, otherwise start optimizing the proc

CHeers

<div>
ConnectionTimeout doesn't work for me, as I change ConnectionString to ADODB.Command and set Time out it's work great. &nbsp;Sorry, all answer is correct but I can give pts to 1 person only.
</div>


ConnectionTimeout doesn't work for me, as I change ConnectionString to ADODB.Command and set Time out it's work great.  Sorry, all answer is correct but I can give pts to 1 person only.

<div>
<div class="content wysiwyg-content">
I receive time out error message for executing ms-sql store procedure message (Timeout expired -2147217871) using ADODB.Connection<br />
<br />
How to I increase Time Out interval?
</div>
</div>


I receive time out error message for executing ms-sql store procedure message (Timeout expired -2147217871) using ADODB.Connection

How to I increase Time Out interval?

Timeout expired for executing ms-sql store procedure?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.