Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Connection Time Out

Author  Topic 

prince500
Starting Member

21 Posts

Posted - 2007-05-22 : 11:55:18
Hi,

Can someone help me on this

When I run simple select query "Select * from Aadata" it works but when I filter with date it doesn't work please see below error:



Error Source : .Net SqlClient data provider

Error Messge: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding



I fixed connection properties:



Connection timeout = 30000

Execution timeout = 30000



Thanks in advance



AA





AA

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-05-22 : 12:00:58
Duplicate" http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83959

Dinakar Nethi
SQL Server MVP
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -