.net won't execute sql command

[Guest]

is there any reason why a sql command will execute in sql server and not in
Vb.Net?
It takes about 1.5 minutes to execute.. Would the timeout have anything to
do with it? If so how do I increase it?

 

[Michael Nemtsev]

Hello Neo,

N> is there any reason why a sql command will execute in sql server and
N> not in
N> Vb.Net?

What do you mean?

N> It takes about 1.5 minutes to execute.. Would the timeout have
N> anything to
N> do with it? If so how do I increase it?

1) To call asynchronously
2) analyze SQL exec plan to improve performance

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsch

 

[Cor Ligthert [MVP]]

Neo,

Yes have a look at the XXXconnection.timeout, don't set it to infinity,
however.

You know that a nice newsgroup for this kind of questions is

microsoft.public.dotnet.framework.adonet

I hope this helps,

Cor