Running stored Procedure in vb.net results in timeout occasionally

[Eddie Suey]

I've created a console app that runs several SPROCs. While running the app
if I access a CD or check my email, I get a timeout error. I'm not sure
why. Is there a way to set a wait variable or something? Does anyone have
any suggestions on how to resolve or debug this issue?

[Robin Tucker]

What are you using to execute the stored proc? If its a SQLCommand object,
you can write:

Command.CommandTimeout = 0

and it'll never timeout! (or of course, more sensible value, such as 120 or
something [seconds])
myCommand.
"Eddie Suey" <es***@inBizServices.com> wrote in message
news:eF*************@tk2msftngp13.phx.gbl...

I've created a console app that runs several SPROCs. While running the app if I access a CD or check my email, I get a timeout error. I'm not sure
why. Is there a way to set a wait variable or something? Does anyone have any suggestions on how to resolve or debug this issue?

[Herfried K. Wagner [MVP]]

* "Eddie Suey" <es***@inBizServices.com> scripsit:

I've created a console app that runs several SPROCs. While running the app
if I access a CD or check my email, I get a timeout error. I'm not sure
why. Is there a way to set a wait variable or something? Does anyone have
any suggestions on how to resolve or debug this issue?

Notice that a separate group for ADO.NET related question is available:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

<http://www.plig.net/nnq/nquote.html>

[esuey]

Thanx. This worked!
I’m feeling a little stupid that I didn’t see this myself.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!