By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,640 Members | 1,598 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,640 IT Pros & Developers. It's quick & easy.

Timeout expired

P: n/a
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
Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Freddy wrote:
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
Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.