database read timeout error

[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

[Paul Roberts]

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

"Dunc" <du**@ntpcl.f9.co.uk> wrote in message
news:u8**************@TK2MSFTNGP11.phx.gbl...

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

[Dunc]

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

Dunc

"Paul Roberts" <Pa*********@nospam.nospam> wrote in message
news:uv*************@TK2MSFTNGP11.phx.gbl...

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

"Dunc" <du**@ntpcl.f9.co.uk> wrote in message
news:u8**************@TK2MSFTNGP11.phx.gbl...

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

[Ignacio Machin \( .NET/ C# MVP \)]

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,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Dunc" <du**@ntpcl.f9.co.uk> wrote in message
news:u8**************@TK2MSFTNGP11.phx.gbl...

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