Timeout expired

[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

 

[Miha Markic [MVP C#]]

Freddy,

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