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.
| Author |
Topic |
|
jn-at-uk
Starting Member
20 Posts |
 Posted - 2005-05-16 : 10:38:51
|
| HiI 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
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]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
jn-at-uk
Starting Member
20 Posts |
Posted - 2005-05-16 : 11:15:07
|
| 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? |
|
|
|
DonAtWork
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* |
|
|
|
|
|
|
sql timeout eror, do i need sp