Timeout with 1.1 Framework

  • Thread starter Thread starter Miha Markic
  • Start date Start date
M

Miha Markic

Hi Paul,

Can you show us some code (connection, command).
What is the value of SqlCommand.CommandTimeout?
 
Hello,

I am using a SQL DataAdapter to query and load a hierarchical grid. I use a
data relation. After upgrading to the .NET 1.1 framework...we now experience
timeouts when we never did before.

When I run the SPROC outside of VB.NET in Enterprise Manager...it
screams...no performance issues at all.

Any ideas,

Paul
 
Hi Paul,

What do you mean by "it screams"? Does it work or not?

And like what Miha said, can you show us some code (connection, command).
What is the value of SqlCommand.CommandTimeout?

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Hi,

I think there is a lock happening in executing the
command, in ur query try using with nolock keyword.
Try this, but this is not an ideal solution.
If you can elaborate ur problem in detail we could help
you.

Regards
Mahesh ChandraMouli
Microsoft .NET MVP|MCAD(Charter Member)
 
Back
Top