ADO.Net SqlDataReader Record Locking? timeout!

[JFritzler]

I am using an ADO.Net SqlDataReader to read through a rather large query. As I process the data I want to execute an "update set x = y" statement on the database using a different command and a different connection (different connect string, timeout value is different) for the row I just read. At runtime I get an sql exception saying my update command timed out. (timeout expired). But the same, except "update" statement works fine outside the app!

Does a SqlDataReader lock the records it is reading? I thought it was "fastforward read-only"?

Is there a parameter I need to set?

 

[JamesLean]

You should probably post this question in the ASP.NET forum:
forum855

--James

 

[JFritzler]

I'll post this in that forum, but this is not specific to ASP.Net at all.