467,859 Members | 1,361 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,859 developers. It's quick & easy.

Odbc SQL Query Timeout Error - VB.Net


I am developing winforms project using vb.net. In this i am connecting SQL 2000 DB using odbc connection. When i run SQL select query i am getting timeout error.
But the same select query runs in the query analyzer for 7 minutes. I have also set the odbccommand.Timeout as 0. But still i have the same problem.

Please it's very urgent.
Sep 16 '08 #1
  • viewed: 4537
1 Reply
Expert 256MB
Wow, a 7 minute query, thats really long.

Are you accessing the DB via a webservice? If so, you also need to set the web service timout to 0. But i suggest you look into creating a database view to help speed up the transaction.
Or you could consider perfoming the transaction in multiple calls, possibly using paging
Sep 16 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Szymon Dembek | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.