Timeout expired

  • Thread starter Thread starter Freddy
  • Start date Start date
F

Freddy

Hi,

I have a .aspx page and a .net assembly. The code wihich accesses the
database and returns a dataset is present in a function within the assembly.
When I try to access this function and try to bind the datagrid with the
dataset returned I get the following error approx. 30 seconds after
accessing the web page.


ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Timeout expired


Can anyone please guide me as to why this might be happening. I set the
ConnectionTimeout as,

objConnection.ConnectionTimeout = 120

Any links to sample code greatly appreciated.

Thanks,

Freddy
 
Freddy,

Try changing command object CommandTimeout property.
BTW, why are you using odbc to connect to sql server?
 
Back
Top