<div>
Hey,<br />
Good call ont he command object timeout. &nbsp;<br />
<br />
That solved the problem!<br />
<br />
I was having one of the crap days when you get stuck in lots and lots of meetings and constantly putting out fires. &nbsp;<br />
<br />
Nice to have an annoying problem solved by someone else.<br />
<br />
Thanks alot!<br />
<br />
Malcolm
</div>


Hey,
Good call ont he command object timeout.  

That solved the problem!

I was having one of the crap days when you get stuck in lots and lots of meetings and constantly putting out fires.  

Nice to have an annoying problem solved by someone else.

Thanks alot!

Malcolm

<div>
<div class="content wysiwyg-content">
Hello,<br />
I want to change the default timeouts for SQL 7.<br />
<br />
My choices are: &nbsp;<br />
<br />
1. Change the connection string<br />
<br />
2. Change it inside of VB6<br />
I use ADODB connection objects to connect to the database.<br />
<br />
I've tried doing a command like gcnn.CommandTimeout = 120, but it always seem to timeout after 30 seconds (the default)<br />
<br />
Any ideas?<br />
<br />
Malcolm<br />
<br />

</div>
</div>


Hello,
I want to change the default timeouts for SQL 7.

My choices are:  

1. Change the connection string

2. Change it inside of VB6
I use ADODB connection objects to connect to the database.

I've tried doing a command like gcnn.CommandTimeout = 120, but it always seem to timeout after 30 seconds (the default)

Any ideas?

Malcolm



SQL timeouts in VB6

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.