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

 

[Rutger Smit]

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

Can you connect manually to the database with your Enterprise Manager?
If so, maybe a firewall blocks access to the SQL Server (can't imagine,
but you never know).

//Rutger