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

 All Forums
 Old Forums
 CLOSED - General SQL Server
 sql timeout eror, do i need sp

Author  Topic 

Starting Member

20 Posts

Posted - 2005-05-16 : 10:38:51
I am getting a timeout error when i debug my app and a
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData(CheckforData()).error when i run a simple select from query analyser. My sql seems to be really slow now.
I have windows2003 server with no sp and SQL2000 with sp3A and the latest hotfix.

thanks in advance


3564 Posts

Posted - 2005-05-16 : 11:04:20
Can you post your sql?
How slow?
I assume you get no results and it times out ?
Does it work in query analyzer ?

Keeping the web experience alive -- [url][/url]
Imperfection living for perfection --
Go to Top of Page

Starting Member

20 Posts

Posted - 2005-05-16 : 11:15:07

I don't think there's any point in me posting my sql as if i write any select statement from query analyser it seems to be taking longer than normal. A select * from a table with 10 000 records is taking 3mins to show results. So it's def. something else.
Waht do u think? Do I need an sp for win2003 server?
Go to Top of Page

Master Smack Fu Yak Hacker

2167 Posts

Posted - 2005-05-16 : 12:41:49
Tell your database admin that it takes 3 mins to do a simple select.

*need more coffee*
Go to Top of Page

- Advertisement -