Odbc SQL Query Timeout Error - VB.Net

[nilaangel78]

Hi,

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.Tim eout as 0. But still i have the same problem.

Please it's very urgent.

[cloud255]

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