database read timeout error

  • Thread starter Thread starter Dunc
  • Start date Start date
D

Dunc

I've got a c# app that reads a database of 3,000 records. "Interesting"
thing is when I access 3 certain records, I get a database timeout error.
The code is very simple, and runs fine for the other 2,999 records, and if I
run the exact same SQL with query analyzer, it runs fine.

Anyone come across a similar problem, or know what I should be looking at
for this?

Dunc
 
When you run the query in your c# code do you have a transaction around it?
If so also add the transaction in query analyser and see if it also fails
there.

Hope that helps
Paul
 
Nope, no transaction. It's just a simple SP that returns 9 very simple
tables. Thanks for the suggestion anyway...

Dunc
 
Hi,

what kind of fields they have? is anybody else accesig the same table from
another application, maybe somebody has a lock on it, are you using a
datareader ?

I have never seen this before, te only thing I can think of is that, that
somebody has locked those records.


cheers,
 
Back
Top