SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 sql timeout eror, do i need sp
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

jn-at-uk
Starting Member

20 Posts

Posted - 05/16/2005 :  10:38:51  Show Profile
Hi
I am getting a timeout error when i debug my asp.net 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

jhermiz
Flowing Fount of Yak Knowledge

USA
3564 Posts

Posted - 05/16/2005 :  11:04:20  Show Profile  Visit jhermiz's Homepage
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 -- http://www.web-impulse.com
Imperfection living for perfection --
http://jhermiz.blogspot.com/
Go to Top of Page

jn-at-uk
Starting Member

20 Posts

Posted - 05/16/2005 :  11:15:07  Show Profile
Hi,

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

DonAtWork
Flowing Fount of Yak Knowledge

2144 Posts

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

*need more coffee*
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000